Slow performance - OracleDataSet

[jimpoe]

I am calling a stored procedure from an OracleDataSet. The stored procedure returns a cursor. When it is called from an OracleDataSet it is taking 2 minutes or more. When I run the same call from a PL/SQL Developer test window it takes 1.2 seconds.

My test app is a form, an OracleSession, and an OracleDataSet.

Any idea why this would be happening.

 

[jimpoe]

This is embarrassing. With a returned cursor the test window does not return the data until you open the parameter's dialog. The duration times are now equivalent between the dataset and the test window.

 

[Marco Kalter]

Thank you for sharing this embarrassing moment with us

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