Inseting CLOB data in to Oracle

sveeramani · Post by **sveeramani** » Mon Jan 22, 2007 9:33 pm

Hi,
I try to insert/update CLOB data in to Oracle . The size of CLOB is set to 2192000 in the job. It's giving internal error , while running. If I reduce the size to 105,000, running fine. Among the five jobs, only one job giving this error.

Experts please help
Regards,
Veera

kcbland · Post by **kcbland** » Mon Jan 22, 2007 9:53 pm

CLOB datatype is not supported. For the job that's failing, is it on updates or inserts? CLOB requires special handling.

sveeramani · Post by **sveeramani** » Mon Jan 22, 2007 10:33 pm

Both insert and update giving problem. I used in other jobs ,it's working fine. May I know the special handling?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 23, 2007 2:15 am

sveeramani wrote:Both insert and update giving problem. I used in other jobs ,it's working fine.

What's different in the job that's giving you the issues?
What data type do you use for CLOBs in the jobs that you say do work?
Have you asked your DBA about space for CLOBs?
What error messages are logged?

kcbland · Post by **kcbland** » Tue Jan 23, 2007 8:05 am

sveeramani wrote:Both insert and update giving problem. I used in other jobs ,it's working fine. May I know the special handling?

Just read for yourself. Depending on which Oracle version, ease with working with CLOBS varies.

http://www.stanford.edu/dept/itss/docs/ ... lob_wh.htm

chulett · Post by **chulett** » Tue Jan 23, 2007 8:36 am

If you have 10g the DBMS_LOB package comes in very handy.