SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

passing a CLOB more than 4000 characters to SP

640875May 30 2008 — edited Jun 3 2008

hi
i am getting some data from a webservcie as an xmlnode.i am accesing the webservice using .net and i am passing that xml node to oracle SP as a CLOB and then using
"dbms_xmlsave.insertxml" to store the data into oracle.

my problem is the data i am getting is huge and my CLOB parameter is not taking more than 4000 characters error is "string literal too long"

can some one help please?????????

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2008

Added on May 30 2008

35 comments

10,752 views