| ORA-24801: illegal parameter value in OCI lob function [message #181918] |
Wed, 12 July 2006 04:03 |
paranis
Messages: 2
Registered: July 2006
|
Junior Member |
|
|
Guys, I am new to SQL and this forum too. I am getting the following error while updating the database,
========================================================
ORA-24801: illegal parameter value in OCI lob function
in "..."
on line 0 of .
ORA-24801: illegal parameter value in OCI lob function
========================================================
The code which used to update the database looks like the following,
OCIClobLocator *ln_clob;
unsigned int cloblen;
unsigned int offset;
unsigned int emptylen = 0;
unsigned int lnlen = strlen(ln);
EXEC SQL ALLOCATE :ln_clob;
EXEC SQL SELECT MYNOTE INTO :ln_clob FROM MY_LONG
WHERE MYOBJECTID = :objectid AND MYOBJECTTYPE = :objecttype FOR UPDATE ;
offset = 1;
EXEC SQL LOB TRIM :ln_clob TO :emptylen;
EXEC SQL LOB WRITE ONE :lnlen FROM :ln
WITH LENGTH :lnlen INTO :ln_clob AT :offset ;
When I update the longnote field, I removed the previous content and enter new information.
Thanks in advance, Parani S
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
