TOraclePackage and Open Cursors

[packwood]

It seems that TOraclePackage does not free its open cursors after executing CallProcedure / CallFunction methods. Is there any method for closing the associated cursors like the TOracleQuery.Close or TOracleDataSet.CloseAll method? I have searched other threads regarding this topic - only insight was to switch to OCI7 - but this does not work either...

Is the TOraclePackage just an encapsulation of the TOracleQuery? Does it offer any other benefits besides the conversion of booleans and access to package global variables?

Thanks for any help!

 

[jedaworks]

I ran into the same problem. I solved it by (I cannot remember which), one of : setting the dataset/query session to nil then reassigning it; or freeing and recreating the dataset. If either of the above solutions do not work, reply here, and I will find the code I used to solve the problem...

I believe the problem stems from the TDataset code, as the same errors will occur with the Borland database components....

 

[Marco Kalter]

The TOraclePackage always keeps exactly 1 cursor opened for executing functions and procedures or accessing variables. The only way to close this cursor is to free the TOraclePackage instance (setting the Session property does not help). I have added an enhancement request for a Close method for the next release.

------------------
Marco Kalter
Allround Automations