Re: Oracle 10g : is possible return a sys ref cursor for sql from clob variable
From: ddf <oratune_at_msn.com>
Date: Fri, 18 Jun 2010 11:51:48 -0700 (PDT)
Message-ID: <5d170a51-d1bd-4268-8d1a-0baff4b65dd3_at_y6g2000pra.googlegroups.com>
On Jun 18, 9:35 am, Santana <paulito.sant..._at_gmail.com> wrote:
> 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
Date: Fri, 18 Jun 2010 11:51:48 -0700 (PDT)
Message-ID: <5d170a51-d1bd-4268-8d1a-0baff4b65dd3_at_y6g2000pra.googlegroups.com>
On Jun 18, 9:35 am, Santana <paulito.sant..._at_gmail.com> wrote:
> 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
Answered in another newsgroup.
David Fitzjarrell Received on Fri Jun 18 2010 - 13:51:48 CDT