From: ddf on
On Jun 18, 9:35 am, Santana <paulito.sant...(a)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