
October 16th, 2004, 03:16 AM
|
|
Contributing User
|
|
Join Date: Mar 2004
Posts: 56
Time spent in forums: < 1 sec
Reputation Power: 10
|
|
Perhaps:
Code:
TYPE t_cursor IS REF CURSOR;
procedure hello(abc IN number ,xyz IN varchar,S_cursor OUT T_CURSOR) IS
v_cursor t_cursor;
begin
open v_cursor for
SELECT D as ID,c,S0 FROM S, L7, (select l from l_a where v_u = 'xyz') x
WHERE L7.mn IS NULL
AND L7.L = x.l;
S_cursor := v_cursor ;
END hello;
|