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

On Jun 18, 9:35=A0am, Santana <paulito.sant...@gmail.com> wrote:
> Hi,
> is possible a function return a sys ref cursor for sql from =A0clob
> variable i ORACLE 10g, something like this :
>
> FUNCTION TEST AS
> RESULT SYS_REFCURSOR;
> L_QS =A0 CLOB ;
> BEGIN
>
> =A0 =A0 =A0 =A0 =A0 =A0 .....
> =A0 =A0 =A0 =A0 OPEN result FOR TO_CHAR(l_Qs);
> =A0 =A0 =A0 =A0 RETURN result ;
>
> END;
>
> The "l_qs" variable have a length like 40.000 characters.
>
> Regards,
> Paulito Santana

Answered in another newsgroup.


David Fitzjarrell