PL/SQL (MOSC)

MOSC Banner

How can I read a BLOB for which i have only read access?

edited Sep 8, 2014 3:26AM in PL/SQL (MOSC) 7 commentsAnswered ✓

Server: oracle version 11.2.0.4 on AIX

Problem:

I want to read a BLOB in a procedure and I have only read access to the BLOB.

When I only use

DBMS_LOB.READ(DatenNK,amountLob,posBlob,abloSatz.BLOB);

then I have no problem.

But when I try to open the BLOB with

DBMS_LOB.OPEN(DatenNK,DBMS_LOB.LOB_READONLY);

then I get an error because I can't change DatenNK.

And why I want to use OPEN (and Close): the literatur says that I will have better performance if I open a Blob befor i read it.

Do you have such an problem? How do yo solve it? Why I get an error during DBMS_LOB.OPEN : I only want read the BLOB?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center