Hello,
I have the following strange behaviour in one of our selects
We have a TOraQuery object we set the sql, prepare, activate, read the data and deactivate
try
dmDaten.qrdummy.SQL.Text := 'select * from pat_allergien ' +
'where paal_kennr = :pKennr';
dmDaten.qrDummy.ParamByName('pKennr').Value := pKennr;
dmDaten.qrDummy.Prepare;
dmDaten.qrDummy.Active := True;
if dmDaten.qrDummy.RecordCount > 0 then
begin
do what we want to do
else
do somethin other
end;
finally
dmDaten.qrDummy.Active := False;
end;
When the procedure ends according to a select on v$open_cursor
the oracle cursor remains open and sql_text contains the select
All the other select or procedures we execute close the cursor.
I tried to add dmDaten.qrDummy.close but it did not close the cursor.
Could you please tell me what's wrong with my code.
Greetings
Andreas
ORacle cursor remains open even after active:=false
Re: ORacle cursor remains open even after active:=false
Sorry for the late reply. We couldn't reproduce the issue by using this code fragment. Could you send us a complete project along with the script for creating the pat_allergien object? For your convenience, please use the e-support form https://www.devart.com/company/contactform.html