ORA-12571 error when call BreakExec procedure

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Hanry
Posts: 2
Joined: Wed 28 May 2008 12:30

ORA-12571 error when call BreakExec procedure

Post by Hanry » Wed 28 May 2008 12:46

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

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 29 May 2008 08:12

This is normal situation. Probably you can do nothing to prevent the error.

Hanry
Posts: 2
Joined: Wed 28 May 2008 12:30

Post by Hanry » Fri 30 May 2008 03:01

I think all I can do is catch this error :cry:

Thank you anyway, Plash. :)

Post Reply