Dear Support team,
I'm making an example of how to use TOraQuery in NonBlocking mode.
I have a stored procedure (SP) always takes 5s in minimum to executed. I execute a query to get data from this SP and call BreakExec to cancel it immediately.
I put it in a loop and do it 20 times. BreakExec works very well.
However, if I do it again and again (100 times for example), I got a small chance (1~2 times) of getting error ORA-12571.
Do you have experience about this case? Is it normal? If not, what are the possible causes?
Thank you in advance for you help.
I'm using:
- Delphi 6
- CoreLab ODAC for Delphi 6 - version 6.10.0.9
- Oracle 10g release 2
- Windows XP SP2
Best regards,
Hanry