dbTalk Databases Forums  

ora-24801 error message

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss ora-24801 error message in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Richard Crawford
 
Posts: n/a

Default ora-24801 error message - 09-23-2003 , 10:28 AM






In trying to migrate one table from SQL Server to Oracle, I got this
message:

ORA-24801: illegal parameter value in OCI lob function

I've looked in my resources and on line but I haven't found any more
helpful information than that. I've checked the structure of the
tables, and both appear to fine. The source table has 68 records, but
only 33 of them are copied from SQL Server before the error is generated.

Where else can I look to find out the source of this error, and how can
I go about fixing it?


Reply With Quote
  #2  
Old   
Sybrand Bakker
 
Posts: n/a

Default Re: ora-24801 error message - 09-24-2003 , 04:34 PM






On Tue, 23 Sep 2003 08:28:50 -0700, Richard Crawford
<rcrawford.cow (AT) remove_herbivore (DOT) unexmail.ucdavis.edu> wrote:

Quote:
In trying to migrate one table from SQL Server to Oracle, I got this
message:

ORA-24801: illegal parameter value in OCI lob function

I've looked in my resources and on line but I haven't found any more
helpful information than that. I've checked the structure of the
tables, and both appear to fine. The source table has 68 records, but
only 33 of them are copied from SQL Server before the error is generated.

Where else can I look to find out the source of this error, and how can
I go about fixing it?

Likely this did generate a trace file in the directory on the server
which is pointed to by the user_dump_dest parameter


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.