Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem with clob size more than 4000bytes

516171Jun 15 2007 — edited Jun 15 2007
hi,

I am exporting data from access to oracle 10g.
but when the data's size is more than 4000bytes in access.
it cann't insert into oracle's clob column.

i have tried two way: throught ODBC and sqlloader.
both failed.

throught ODBC,the error is:
ODBC--call failed.
[Oracle][ODBC][Ora]ORA-24801: in OCI lob function...(#24081)

who can help me ?
thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2007
Added on Jun 15 2007
2 comments
1,452 views