Hi all,
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

-- 
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

Reply via email to