- dotConnect for Oracle 5.35.79.0 in OCI mode
Visual Studio 2008 Version 9.0.30729.1 SP
.NET Version 3.5 SP1
Server: Oracle 11g R2 64bit
Client: Oracle Instant Client 11.1.0.1
Code: Select all
SELECT * FROM TEX11.CONTRACTS_SEC_FS
Code: Select all
System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
The CONTRACTS_SEC_FS table is an empty table with deferred segment creation, a new R2 feature. I don't know if this is the issue but it is what distinguishes the table from the others in the schema. The DDL follows:
Code: Select all
--DDL Script for TABLE "TEX11"."CONTRACTS_SEC_FS"
CREATE TABLE "TEX11"."CONTRACTS_SEC_FS"
(
"CONTRACT_ID" NUMBER(12,0),
"CONTRACT_NAME" VARCHAR2(80),
"FILE_SIZE" NUMBER,
"ORIG_FILE" BLOB ) SEGMENT CREATION DEFERRED
PCTFREE 60 PCTUSED 5
INITRANS 2
MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS 240
PCTINCREASE 15 FREELISTS 2
FREELIST GROUPS 3
BUFFER_POOL RE
CYCLE FLASH_
CACHE
DEFAULT CELL_FLASH_
CACHE DEFAULT)
TABLESPACE "DSP" LOB ("ORIG_FILE") STORE AS SECUREFILE
(
TABLESPACE "DSPLOB" ENABLE
STORAGE IN ROW CHUNK 8192
NOCACHE NOLOGGING NOCOMPRESS KEEP_DUPLICATES )
CREATE UNIQUE INDEX "TEX11"."SYS_IL0000109860C00004$$" ON "TEX11"."CONTRACTS_SEC_FS"
(
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE
(
INITIAL 65536
NEXT 1048576
MAXEXTENTS 2147483645)
TABLESPACE "DSPLOB" PARALLEL (DEGREE 0 INSTANCES 0);