Page 1 of 1

Call procedure by synonym fires OnError DB trigger

Posted: Tue 09 Jun 2015 11:21
by Starina
Hi.

When trying to call stored procedure with TOraStoredProc component by it's synonym PL/SQL code executes as expected, but "ORA-04043: object does not exist" error gets generated on DB side (detected via OnError trigger).

Described behaviour is observed in Delphi XE2 with ODAC 9.4.12 and ODAC 9.5.15 running on Windows 7 x64 Professional SP1, but NOT in Delphi 7 with ODAC 9.4.12 on the same machine.

Thanks.

Re: Call procedure by synonym fires OnError DB trigger

Posted: Tue 09 Jun 2015 12:47
by AlexP
Hello,

We can't reproduce the described case. Please send a simple application and scripts for creating the stored procedure and alias to alexp*devart*com.

Re: Call procedure by synonym fires OnError DB trigger

Posted: Tue 09 Jun 2015 13:59
by Starina
Thanks for the replay.

The small note: the error occurs when using package.

I prepared simple application and scripts, please repost your email.

Re: Call procedure by synonym fires OnError DB trigger

Posted: Wed 10 Jun 2015 05:52
by AlexP
alexp[dog]devart[dot]com