Hi,
I get error:
Access violation at address 6054C8E0 in module 'oracommon9.dll'. Read address 0000008C.
My code (oQ: TOracleQuery):
with oQ do begin
clear;
SQL.Add('begin');
SQL.Add('bcDML.sel
CC,''select * from dual'');');
SQL.Add('end;');
deleteVariables;
declareVariable('CC',otCursor);
SetComplexVariable('CC',cQ);
Execute; // error
end;
bcDML is Oracle package:
create or replace package bcDML is
type tC is ref cursor;
procedure sel(p_out in out tC, p_1 in varchar2);
end bcDML;
/
create or replace package body bcDML is
procedure sel(p_out in out tC, p_1 in varchar2) is
C tC;
begin
open C for p_1;
p_out := C;
end;
end bcDML;
I get error:
Access violation at address 6054C8E0 in module 'oracommon9.dll'. Read address 0000008C.
My code (oQ: TOracleQuery):
with oQ do begin
clear;
SQL.Add('begin');
SQL.Add('bcDML.sel

SQL.Add('end;');
deleteVariables;
declareVariable('CC',otCursor);
SetComplexVariable('CC',cQ);
Execute; // error
end;
bcDML is Oracle package:
create or replace package bcDML is
type tC is ref cursor;
procedure sel(p_out in out tC, p_1 in varchar2);
end bcDML;
/
create or replace package body bcDML is
procedure sel(p_out in out tC, p_1 in varchar2) is
C tC;
begin
open C for p_1;
p_out := C;
end;
end bcDML;