Could I use as a subquery a cursor returned by a procedure?
From: <biroska_at_gmail.com>
Date: Thu, 14 Nov 2013 05:32:29 -0800 (PST)
Message-ID: <27f200f4-a66b-41e4-b18f-cc1c0b5ece73_at_googlegroups.com>
Hi,
begin
t_cursor sys_refcursor;
qtd_reg number;
BEGIN dbms_output.put_line('----- '||str_valor||' -------'); teste(str_valor, t_cursor);
Date: Thu, 14 Nov 2013 05:32:29 -0800 (PST)
Message-ID: <27f200f4-a66b-41e4-b18f-cc1c0b5ece73_at_googlegroups.com>
Hi,
I have this procedure:
procedure teste( str_valor in varchar2 , split_array out SYS_REFCURSOR)is
begin
open split_array for
select distinct regexp_substr(str_valor,'[^,]+', 1, level) as valor from dual connect by regexp_substr(str_valor, '[^,]+', 1, level) is not null;END teste;
And i would like use the split_array variable as a subquery, something like this:
set serveroutput on;
declare
str_valor varchar2(200) := '10,11,12,13'; valor varchar2(200);
t_cursor sys_refcursor;
qtd_reg number;
BEGIN dbms_output.put_line('----- '||str_valor||' -------'); teste(str_valor, t_cursor);
select count(1) into qtd_reg from table_aux p where p.code in (t_cursor);
CLOSE t_cursor;
END; Is it possible? I already tried assossiative array and no sucess too.
Thank you... Received on Thu Nov 14 2013 - 14:32:29 CET