Oracle 10g : is possible return a sys ref cursor for sql from clob variable

[Santana]

Hi,
is possible a function return a sys ref cursor for sql from clob
variable i ORACLE 10g, something like this :


FUNCTION TEST AS
RESULT SYS_REFCURSOR;
L_QS CLOB ;
BEGIN

.....
OPEN result FOR TO_CHAR(l_Qs);
RETURN result ;

END;


The "l_qs" variable have a length like 40.000 characters.

Regards,
Paulito Santana

[ddf]

The CLOB data will be truncated to 32767 characters in PL/SQL as
that's the ultimate length of a VARCHAR2 in that environment. You
won't get your 40,000 characters returned.

There may be other restrictons with ref cursors and LOB data that I am
not aware of.


David Fitzjarrell