Home -> Usenet -> c.d.o.server -> Oracle 10g : is possible return a sys ref cursor for sql from clob variable

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

From: Santana <paulito.santana_at_gmail.com>
Date: Fri, 18 Jun 2010 06:35:08 -0700 (PDT)
Message-ID: <6ab6cc86-137b-496f-8caf-da9ab6fdac6b_at_b35g2000yqi.googlegroups.com> 






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
Received on Fri Jun 18 2010 - 08:35:08 CDT












Original text of this message