The create or replace package body PKG_TEST is

Function FUNC_QUERY return v_cursor is - how to return???????

Cursor v_cursor is
The select TRD. * from TRD TRD
Where TRD. Fintyp='RAO';
The begin
Return v_cursor; - return explicit cursor
end;

Procedure PROC_QUERY is
Cursor v_cursor; -- -- --???
V_row_trd TRD % rowtype; -- -- --???
The begin
V_cursor: FUNC_QUERY_TRD=(); - would like to receive () function returns the explicit swim here values

- here is a for traversing the cursor

end;

End PKG_TEST;

CodePudding user response:

The original poster can exam the pipeline function,

CodePudding user response:

reference 1st floor selling fruit net reply:

the original poster can exam the pipeline function,

For Oracle PL/SQL no foundation, what is the relationship between pipeline function and cursor? Found function returns SYS_REFCURSOR implicit cursor example, but how returns cursor cursor? Please help me with the