Devart Forums

When opening a table which contains XMLTYPE columns the ODAC component raises an exception:

OCI-21500: Interner Fehlercode, Argumente: [kocgpn129], [2], [], [], [], [], [], []

call stack:

OraError(21500,nil)
Check(-1,nil)
TOraObject.FreeObject(True)
TOraXML.FreeObject(???)
TOraObject.SetInstance($1DBB10C0)
PrepareBlock(???)
TOCIRecordSet.FetchArray(False)
TOCIRecordSet.Fetch(False)
TCRRecordSet.GetNextRecord($1A031F1C)
TMemDataSet.GetRecord('ۊ ',???,True)

hints:
- with version 5.55.1.24 it works
- using a view (CREATE VIEW v AS SELECT * from t) it also works in 5.55.1.26

It would be great if you can give me some hint about this issue.

Sorry I forgot:

- we are using Oracle 9.2.0.7 (both client and server)
- we use a grid control (DeveloperExpress QuantumGrid 5) to show the content of the table. As soon as the table containing XMLTYPE fields is assigned to the DataSet property of the component the exception is raised

Further informations:

- we use Delphi 7

- I found out, that it works with some tables containing XMLTYPE fields

- I dropped + recreated the table which never worked (see below for table structure): now showing the table the first time works; switching to another table and then back -> exception; again switch to another table and back -> it works; for further table switches it works.

- structure of the table:

CREATE TABLE TESTTBL (
FPK INTEGER NOT NULL PRIMARY KEY,
FFLOAT FLOAT,
FNUMBERINT NUMBER(10,0),
FNUMBER NUMBER(15,5),
FTIMESTAMP TIMESTAMP(6),
FDATE DATE,
FLONG LONG,
FCHAR10 CHAR(10),
FCHAR CHAR,
FVARCHAR VARCHAR2(2500),
FXML1 XMLTYPE,
FXML2 XMLTYPE,
FCLOB1 CLOB,
FCLOB2 CLOB,
FBLOB BLOB
);

(without the 2 XMLTYPE fields it always works)

We have already fixed this problem. This fix will be included in the next ODAC build.

thanks for the really fast answer. Can you tell me when the next build will be released? (we have to release on January, 25.; is it possible to get a build before that date?)

The new build of ODAC will be released this week.

The new build of ODAC will be released this week.

Sorry to bother you, but where can I download the new ODAC release? On the download page there is still version 5.55.1.26 (16.12.05).

Next build of ODAC will be available this week

Executing a select statement in which one of the fields is XMLType.

This error is *not* consistent, sometimes the select works, sometimes it does not!

CoreLab.Data.dll is v4.70.23.0
CoreLab.Oracle is v4.70.38

Visual Studio 2005 (vb.net)

Any ideas??

Thanks!