Database Administration (MOSC)

MOSC Banner

Desired to know the different between session duration & call duration used with dbms_lob.createtemp

edited Sep 12, 2014 5:04AM in Database Administration (MOSC) 1 commentAnswered

declaration:

DBMS_LOB.CREATETEMPORARY (

   lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,

   cache   IN            BOOLEAN,

   dur     IN            PLS_INTEGER := 10)

  

the dbms_lob.createtemporary() has two available values for its dur parameters

DBMS_LOB.SESSION: the temporary LOB is cleaned up at the end of the session

DBMS_LOB.CALL: the temporary LOB is cleaned up at the end of the call

I need to know the difference between them, so I do the following tests but the result shows that they did not.

--with DBMS_LOB.CALL

variable clb clob;

variable ch varchar2(4000);

variable k number;

exec dbms_lob.createtemporary(:clb,true,dbms_lob.call);  

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