PL/SQL (MOSC)

MOSC Banner

Variable Assignment vs DBMS_LOB.COPY

edited Feb 28, 2011 1:32PM in PL/SQL (MOSC) 9 commentsAnswered
 Hi,

 Is there any difference between assigning the lob object directly (1 below) to a lob variable and by using dbms_lob.copy (2 below)  if i am copying the complete document?

Declare

a blob;

b blob;

Begin

 Select lob1 into a from xxt;

b := a; -- 1

dbms_lob.copy(b,a,dbms_lob.get_length(a)); -- 2

End;

Thanks,

Lakshmi.

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