trouble to insert into SYS.XMLType

From: Alexander A.Danilov <alteest_at_rambler.ru>
Date: Fri, 20 Feb 2004 09:31:33 +0500
Message-ID: <c142kl$ce8$1@image.surnet.ru>

hi all
this is code to insert into SYS.XMLType column (in *.pc file):

EXEC SQL PREPARE InsertObj FROM :oraSqlstmt; oraERR_CHECK(PersistentStore,CreateObject,uFalse);

EXEC SQL DESCRIBE BIND VARIABLES FOR InsertObj INTO _insertDesc; oraERR_CHECK(PersistentStore,CreateObject,uFalse);

_insertDesc->N = _insertDesc->F;
.
.
.

qdes->L[*col] = len;
qdes->V[*col] = (char *) _dbBuffer;
qdes->T[*col] = psOracleExternalTypeLONGVARCHAR; // Oralce LONG VARCHAR (94)
qdes->I[*col] = & _dbIndicator;

.
.

EXEC SQL EXECUTE InsertObj USING DESCRIPTOR _insertDesc;

but i have error
ORA-01461 can bind LONG value only for insert into a LONG column whats wrong? may be for SYS.XMLType its need to use other type, but what type?

P.S. sorry for my english Received on Thu Feb 19 2004 - 22:31:33 CST