Home » Developer & Programmer » Precompilers, OCI & OCCI » Unable to Insert XML data into XMLType Table :-( (Oracle 11G Release 1)
Unable to Insert XML data into XMLType Table :-( [message #376161] Tue, 16 December 2008 06:13 Go to next message
mail4kaja
Messages: 2
Registered: December 2008
Location: Chennai
Junior Member
[size=2]Hi all,

I want to insert XML data into my ( Oracle 11G Release 1 ) XMLType table using OCCI. I'm getting


ORA-01461: can bind a LONG value only for insert into a LONG column

My XML data size is around 1.5 to 2MB. I have also tried using setMaxParamSize before calling the setString method. But, still I'm getting the same exception.

How to resolve this issue?

Thanks in advance,

With regards,
R Kaja Mohideen

[Updated on: Tue, 16 December 2008 06:52] by Moderator

Report message to a moderator

Re: Unable to Insert XML data into XMLType Table :-( [message #376170 is a reply to message #376161] Tue, 16 December 2008 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without the code we can't say but I think the message is clear: you don't use the correct variable.

And don't put a link to your site, Marketplace forum is there for this.

Regards
Michel
Re: Unable to Insert XML data into XMLType Table :-( [message #376230 is a reply to message #376170] Tue, 16 December 2008 09:10 Go to previous message
mail4kaja
Messages: 2
Registered: December 2008
Location: Chennai
Junior Member
Actually, I'm trying to insert XML Data into a XMLType Table. Since, XMLType can't be receiving more than 4K of data through OCCI ( I got this info from somewhere on web ). I have tried to use a PL/SQL to load my data into a LONG variable and insert that data into my table.

[Updated on: Tue, 16 December 2008 09:11]

Report message to a moderator

Previous Topic: Problem connect to Database!Please help me
Next Topic: Ora-12154 when working with Pro*fortran.
Goto Forum:
  


Current Time: Thu Mar 28 07:58:34 CDT 2024