Call procedure by synonym fires OnError DB trigger

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Starina
Posts: 16
Joined: Tue 14 Dec 2004 15:17

Call procedure by synonym fires OnError DB trigger

Post by Starina » Tue 09 Jun 2015 11:21

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.
Last edited by Starina on Tue 09 Jun 2015 13:01, edited 1 time in total.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Call procedure by synonym fires OnError DB trigger

Post by AlexP » Tue 09 Jun 2015 12:47

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.

Starina
Posts: 16
Joined: Tue 14 Dec 2004 15:17

Re: Call procedure by synonym fires OnError DB trigger

Post by Starina » Tue 09 Jun 2015 13:59

Thanks for the replay.

The small note: the error occurs when using package.

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Call procedure by synonym fires OnError DB trigger

Post by AlexP » Wed 10 Jun 2015 05:52

alexp[dog]devart[dot]com

Post Reply