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!

how to insert string into blob.

947771Jul 16 2013 — edited Jul 17 2013

hi,

i have a stored procedure where i  am getting string in a parameter.

which i have to insert into blob column.

so i am using following .

--Insert into t values (utl_raw.cast_to_raw('hello'));

please tel me is it correct and if there is any better solution then please suggest ,

note: do not want to change column type in database it will be blob.

and in stored procedure the parameter  can be of any type but it will get string data only we have char or varchar etc , which can be used.

yours sincerely

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2013
Added on Jul 16 2013
5 comments
8,440 views