Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Tuesday, May 30, 2006

HOW-TO return CLOB datatype in PL/SQL

CREATE OR REPLACE PROCEDURE Clobtestproc(o_clob OUT CLOB)
AS
tmpclob CLOB;
tmpxml VARCHAR2(100);
BEGIN
tmpxml :='ABC';
DBMS_LOB.createtemporary(tmpclob, FALSE);
DBMS_LOB.WRITE (tmpclob,LENGTH (tmpxml), 1, tmpxml);
o_CLOB := tmpclob;
DBMS_LOB.freetemporary(tmpclob);
END;
/

0 Comments:

Post a Comment

<< Home