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!

How to insert NULL in to a BLOB column

843854Sep 19 2003 — edited Sep 19 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):

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.


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