How to Convert from Long Raw to BLOB/CLOB using PL/SQL

 In note  [ID 1012454.7] ,How to use the below procedure?

CREATE OR REPLACE PROCEDURE Long2Lob( 
-- Uses DBMS_SQL to select a LONG column identified by p_LongQuery, and 
-- returns it in p_CLob. 
p_LongQuery IN VARCHAR2, 
p_CLob IN OUT CLOB) AS 

c_ChunkSize CONSTANT INTEGER := 100; 

v_CursorID INTEGER; 
v_RC INTEGER; 
v_Chunk VARCHAR2(100); 
v_ChunkLength INTEGER; 
v_Offset INTEGER := 0; 
BEGIN 
-- Open the cursor, define, execute, and fetch. 
v_CursorID := DBMS_SQL.OPEN_CURSOR; 
DBMS_SQL.PARSE(v_CursorID, p_LongQuery, DBMS_SQL.V7); 
DBMS_SQL.DEFINE_COLUMN_LONG(v_CursorID, 1); 
v_RC := DBMS_SQL.EXECUTE_AND_FETCH(v_CursorID);