M
Matthew Houseman
All,
I've created a synonym that points to a package over a database link
like so:
CREATE SYNONYM API_MYLINK FOR (e-mail address removed)
I've granted execute like so:
grant execute on csapi_v2 to scott;
When I attach to the database in C# and attempt to dispatch a stored
procedure using the synonym like so: API_MYLINK.Create_Invoice
I get the following exception raised:
Oracle.DataAccess.Client.OracleException ORA-00604: error occurred at
recursive SQL level 1
Is what I'm trying to do even possible and if so, can someone provide
a code snippet demonstrating the dispatch of a stored procedure over a
database link.
Thanks,
Matt Houseman
I've created a synonym that points to a package over a database link
like so:
CREATE SYNONYM API_MYLINK FOR (e-mail address removed)
I've granted execute like so:
grant execute on csapi_v2 to scott;
When I attach to the database in C# and attempt to dispatch a stored
procedure using the synonym like so: API_MYLINK.Create_Invoice
I get the following exception raised:
Oracle.DataAccess.Client.OracleException ORA-00604: error occurred at
recursive SQL level 1
Is what I'm trying to do even possible and if so, can someone provide
a code snippet demonstrating the dispatch of a stored procedure over a
database link.
Thanks,
Matt Houseman