Re: How to refer to remote procedure

It should work. Is the proc valid? What errors did you get? Try recompiling it and do a "desc proc_at_dblink". It certainly works in 9i and I don't seem to recall remote proc behave differently in earlier versions of ORACLE. Schema.proc_at_dblink, proc_at_dblink, or creat a synonym for it, all should work.

jshubo_at_yahoo.com (Jambo) wrote in message news:<cd48a5b6.0208051859.5defa9d1_at_posting.google.com>...
> since we can refer to remote table via database link such as
> 'table1_at_dblink'.
>
> but when I try to refer to the procedure(PL/SQL) located remotely via
> database linke like 'procedure_at_dblink', it doesn't work.
>
> can anyone tell how to fix this?
Received on Tue Aug 06 2002 - 08:33:54 CEST