dbTalk Databases Forums  

trouble to insert into SYS.XMLType

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss trouble to insert into SYS.XMLType in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alexander A.Danilov
 
Posts: n/a

Default trouble to insert into SYS.XMLType - 02-19-2004 , 03:18 AM






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


EXEC SQL PREPARE InsertObj FROM raSqlstmt;
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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.