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
Inseting CLOB data in to Oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Wed Apr 20, 2005 9:24 am
CLOB datatype is not supported. For the job that's failing, is it on updates or inserts? CLOB requires special handling.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 3
- Joined: Wed Apr 20, 2005 9:24 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What's different in the job that's giving you the issues?sveeramani wrote:Both insert and update giving problem. I used in other jobs ,it's working fine.
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Just read for yourself. Depending on which Oracle version, ease with working with CLOBS varies.sveeramani wrote:Both insert and update giving problem. I used in other jobs ,it's working fine. May I know the special handling?
http://www.stanford.edu/dept/itss/docs/ ... lob_wh.htm
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle