Home » SQL & PL/SQL » SQL & PL/SQL » ORA-24801: illegal parameter value in OCI lob function
icon5.gif  ORA-24801: illegal parameter value in OCI lob function [message #181513] Mon, 10 July 2006 06:31 Go to next message
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
Re: ORA-24801: illegal parameter value in OCI lob function [message #206390 is a reply to message #181513] Wed, 29 November 2006 19:16 Go to previous messageGo to next message
artmast
Messages: 11
Registered: October 2006
Junior Member
ORA-24801 illegal parameter value in OCI lob function
Cause
One of the parameter values in the OCI LOB function is illegal.

Action
Check every parameter in the OCI Lob function call to make sure they are correct. Offsets should be greater than or equal to one.

This is from http://oratip.com/ORA-24801.html
Re: ORA-24801: illegal parameter value in OCI lob function [message #206549 is a reply to message #206390] Thu, 30 November 2006 08:49 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Ok already, stop hawking your website about oracle errors by answering questions that have been dormant for 6 months.
I would much rather trust a site with the real Oracle documentation to give information on Oracle errors, rather than an interpretation or a cut and paste of pieces of it.
Previous Topic: Select statements
Next Topic: SELECT Count question
Goto Forum:
  


Current Time: Fri Dec 09 13:37:22 CST 2016

Total time taken to generate the page: 0.22965 seconds