Home » Developer & Programmer » Precompilers, OCI & OCCI » ORA-24801: illegal parameter value in OCI lob function
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
Previous Topic: pl/sql package and Pro C
Next Topic: pro*c++ _sllcxt error
Goto Forum:
  


Current Time: Thu Mar 28 04:58:02 CDT 2024