Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ORA-24801 illegal parameter value in OCI lob function

Posted on 2008-10-14
1
Medium Priority
?
2,222 Views
Last Modified: 2013-12-19
Dear Sirs,

When I try to save in a field clob the error appear (only using oracle 9i.),  using oracle 10g does work well

I am using a Visual Foxpro program!

Any idea?

Tahnks in adavance!
Jose
0
Comment
Question by:dclsoft
1 Comment
 
LVL 15

Accepted Solution

by:
Shaju Kumbalath earned 2000 total points
ID: 22718379
The Oracle documentation has the following to say about the error ORA-24801:
"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."

If you've checked, and it appears that all your parameters are coded properly and you still receive the ORA-24801, you may simply need to  upgrade the client."

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question