PL/SQL (MOSC)

MOSC Banner

Can you view LOB Locator?

in PL/SQL (MOSC) 6 commentsAnswered

Hi there,


This is a general question: I have a table with a BLOB column defined on it. There are records in this table with the BLOB column populated. I have a procedure which will update this BLOB column; it takes an IN parameter that is also of BLOB type. If I do a simple:


UPDATE blob_tbl
 SET   blob_column = IN_blob_value;
COMMIT;

Will this create a new LOB Locator for the UPDATED value in that BLOB column, or will it update the existing BLOB value with the content from IN_blob_value and retain the same LOB locator value?

Tagged:

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