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!

Updating column with BLOB datatype

2948752Jul 15 2015 — edited Jul 15 2015

Hi All,

I am trying to update a column of BLOB datatype in a table . My statement is as below:

UPDATE tablename

SET BLOBVALUE = 'TEST'

WHERE TASKID = '********';

But the above statement is throwing the below error:

SQL Error: ORA-01465:  "invalid hex number"

Please help me with this.

Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2015
Added on Jul 15 2015
15 comments
1,629 views