I have a procedure which looks something like this:
PROCEDURE GETIDS(
iID_LIST IN CLOB
...
In the procedure I do the following to prepare for some string parsing:
DBMS_LOB.CREATETEMPORARY( t_LOB, TRUE );
DBMS_LOB.COPY( t_LOB, iID_LIST, DBMS_LOB.GETLENGTH(...