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 read a BLOB column in oracle

NewLearnerJul 9 2014 — edited Jul 9 2014

Hi,

I have two queries

1. I have a column which of data type BLOB. When I do a select * from table...The column is being displayed as (BLOB)...How can I check the value using a query

2. I have a PL-SQL procedure that has an input parameter of type BLOB. The procedure actually inserts the data to table. How can I test my procedure for BLOB column. How can I send say abc.txt file as input parameter to my procedure and it in in turn inserts the contents of abc.txt to the BLOB column. Please help.

My oracle version is 11g.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2014

Added on Jul 9 2014

3 comments

11,696 views