I have a stored procedure in one database and i granted EXECUTE
privilege to PUBLIC. I also created a public synonym for that stored
procedure.
I am trying to call the procedure from another database. I have db
link
to the remote database and I have synonym created for that procedure
in my local database also.
I am able to call the remote procedure from an anonymous block
but I am not able to call the same procedure from a stored procedure.
What I am missing here ? What I should do to be able to call the
remote stored procedure from my local stored procedure.
Thanks
Pushparaj
Received on Wed May 23 2001 - 18:02:46 CEST