OraFAQ Forum: Server Utilities » problem with export illegal parameter value in OCI lob function

Home » RDBMS Server » Server Utilities » problem with export illegal parameter value in OCI lob function (oracle 10 g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem with export illegal parameter value in OCI lob function [message #490207]

Fri, 21 January 2011 16:38

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 ?

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Pre-requisite For Oracle Critical Patch Updates
Next Topic:	imp Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 23:00:52 CST 2025