Skip to Main Content

Java Database Connectivity (JDBC)

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!

ORA-00600 error when inserting NULL in BLOB column

404230Sep 19 2003 — edited Sep 22 2003
Hi,

I want to insert NULL value into a BLOB column w/o using empty_blob(), but I am getting the following error upon submission (both through program and upon directly executing it from TOAD/SQL*):

java.sql.SQLException: ORA-00600: internal error code, arguments: [kxtotolc_lobopt], [], [], [], [], [], [], []


The query is as follows:

insert into image_rendering r
(r.Version_date_time, r.id, r.Name, r.Type, r.Image_url, r.Image_filesize, r.Html, r.Original_Text, r.Redirect_url, r.Version, r.Rendering_size) values
(sysdate, '1963884', '468x60_1.gif', '0', '225/9-468x60_1.gif', '1471', null, null, null, '1', '30670908')

In the table r.Html, r.Original_Text are blob and clob columns respectively.

If I remove the column r.Html (blob) and its corresponding value the following query executes fine :

insert into image_rendering r
(r.Version_date_time, r.id, r.Name, r.Type, r.Image_url, r.Image_filesize, r.Original_Text, r.Redirect_url, r.Version, r.Rendering_size)
values
(sysdate, '1963884', '468x60_1.gif', '0', '225/9-468x60_1.gif', '1471', null, null, '1', '30670908')


I know I can also insert the query using the string empty_blob(), but I dont want to do it without using empty_blob() since it will involve changing my generic DB classes.

The strange thing is that I created another table involving blob and clob columns through TOAD.
In this table I can insert NULL values in the blob column without any error.

Is there anything that can be done to insert a NULL into my blob column? Am I missing anything?
Is there a setting in the database that will allow me to do this? cuz one table accepts null and the other doesn't. Its strange.


I am using Oracle8i Enterprise Edition Release 8.1.7.0.0
The query doen't execute through toad or sql* plus or through program (I am using thin oracle drivers: the usual classes12.zip file)

thanks in advance
- Nilesh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2003
Added on Sep 19 2003
1 comment
1,068 views