I'd like to get a table and other out parameter(s) from the OraStoredProcedure.
For example:
Code: Select all
create or replace package SelTeszt is
TYPE tRecData IS RECORD (
fiokkod varchar2(4),
szamlaszam varchar2(12)
) ;
TYPE tTblRecData is TABLE of tRecData;
PROCEDURE Get_Data(rcData OUT SYS_REFCURSOR, i_out out number);
end SelTeszt;
/
create or replace package body SelTeszt is
PROCEDURE Get_Data(rcData OUT SYS_REFCURSOR, i_out out number) as
rData tRecData;
aData tTblRecData;
begin
i_out := 100;
aData := tTblRecData();
rData.fiokkod:='0300';
rData.szamlaszam:='012345678';
aData.Extend;
aData(aData.Last):= rData;
rData.fiokkod:='0400';
rData.szamlaszam:='987654321';
aData.Extend;
aData(aData.Last):= rData;
open rcData for SELECT fiokkod, szamlaszam FROM table(aData);
end;
end;
/
In OraStoredProcedure the AutoClose option is set True;
How can I close the unused cursor, without session reconnect or do I have to use a different method to get the parameters?
versions:
os: windows 10
oracle: 12
delphi: 10.2
odac: 10.0.1
Thank You for your help.
Yours sincerely:
KisA