AV error with cursor variable

marek

Member²
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;
 
Could it be that the StatementCache for the session is enabled?

------------------
Marco Kalter
Allround Automations
 
Back
Top