TOracleSessionPool with ref cursor

[Henrique]

We are using DOA with Oracle 12C. In on-promise environment everything works just fine.
When we were working on the Oracle Cloud, the login and logoff process was very slow, leaving the system slow as a whole, and then we started using the TOracleSessionPool component. Using this component the system returned to be fast but we are faced with a big problem. All the TOracleDataSet components that receive a cursor type of "ref cursor" have the following error:

Project SrvMegaFinanc.exe raised exception class EAccessViolation with message 'Access violation at address 545997E3 in module 'oracommon12.dll'. Read of address 00000094'.

After

Project SrvMegaFinanc.exe raised exception class EOracleError with message 'ORA-01013: user requested cancel of current operation'.

We tried to create a new TOracleSession component to handle these Ref Cursor queries, but the errors persist intermittently.

Can you help us?

 

[Marco Kalter]

Do you first get the ORA-01013 error, or the Access Violation?

Does it help if you change the session pool from ptOracle to ptDefault?

 

[Henrique]

First - Access Violation
Second - ORA-01013

I'm going to test changing the session pool

 

[Henrique]

Do you have any suggestions?
For now, to solve the problem, I created a new TOracleSession without pool to work without problems, however this is what we call in Brazil of "gambiarra", that is, we implemented a non-professional code only to resolve provisionally.

 

[Marco Kalter]

Did you already change the session pool from ptOracle to ptDefault?

 

[Henrique]

Yes, I did but nothing. The problem is the same.