Re: Accessing stored procedures from Forms4.5

Create public synonyms.

Susan Frady <sfrady_at_mail.sdsu.edu> wrote in article <3486FCFF.1BD2_at_mail.sdsu.edu>...
> Hi All -
>
> We have a new database containing some stored packages/procedures which
> we need to call from our forms. We have granted execute on all the
> stored procedures to the role to which user X belongs. How can we call
> the stored procedures so that when user X is running the form, she can
> access user Y's stored procedures?
>
> We tried using the OWNER.PROCEDURE_NAME notation in the calling form,
> but the local procedure would not compile this way. What basic step are
> we overlooking here?
>
> Thanks for any assistance,
> Susan Frady
> San Diego State University
>
Received on Fri Dec 05 1997 - 00:00:00 CET