ODP.NET, stored procedures and database links

All,

I've created a synonym that points to a package over a database link like so:
CREATE SYNONYM API_MYLINK FOR USER.CSAPI_V2_at_INSTANCE.DOMAIN.COM 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 Received on Fri Sep 26 2003 - 15:37:23 CDT