Prev: cluster_database_instances less than actual number of instance, any harm?
Next: Urgent Requirement
From: Santana on 18 Jun 2010 09:35

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
 | 
Pages: 1
Prev: cluster_database_instances less than actual number of instance, any harm?
Next: Urgent Requirement