Home » RDBMS Server » Server Utilities » problem with export illegal parameter value in OCI lob function (oracle 10 g)
problem with export illegal parameter value in OCI lob function [message #490207] Fri, 21 January 2011 16:38 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
We are trying to export our production data .

We got this error
. . exporting table                        EA_BLOB
EXP-00056: ORACLE error 24801 encountered
ORA-24801: illegal parameter value in OCI lob function



please tell me how to overcome this error ?
Re: problem with export illegal parameter value in OCI lob function [message #490210 is a reply to message #490207] Fri, 21 January 2011 17:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>please tell me how to overcome this error ?
file a Service Request with Oracle Support.
Re: problem with export illegal parameter value in OCI lob function [message #490221 is a reply to message #490207] Sat, 22 January 2011 00:27 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.


As Blackswan said, this smells a bug.

Regards
Michel
Previous Topic: Pre-requisite For Oracle Critical Patch Updates
Next Topic: imp Issue
Goto Forum:
  


Current Time: Fri Mar 29 05:53:52 CDT 2024