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.
Call procedure by synonym fires OnError DB trigger
Call procedure by synonym fires OnError DB trigger
Last edited by Starina on Tue 09 Jun 2015 13:01, edited 1 time in total.
Re: Call procedure by synonym fires OnError DB trigger
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.
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
Thanks for the replay.
The small note: the error occurs when using package.
I prepared simple application and scripts, please repost your email.
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
alexp[dog]devart[dot]com