Re: help on privilege.. URGENT

try
dbms_sql.EXECUTE <<procedure name>>

In article <9egmv9$hfm1_at_biko.telecom.ups.com>, "Bigfoot" says...
>
>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 - 20:19:10 CEST