Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ORA-24801 illegal parameter value in OCI lob function

Posted on 2008-10-14
1
Medium Priority
?
2,197 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

963 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