Re: Forms 4.5 help

Hi Cindy

Your trigger either needs to expicitly call

 dba_name.procedure_name

or you need to create a synonym for the
procedure. Either a public synonym or
a private synonym for each user who
should be able to call the procedure.

Create public synonym procdure_name

      for dba_name.procedure_name;

John  

>Subject: Forms 4.5 help
>From: Cindy Swafford <Cindy_Swafford_at_pacibm.org>
>Date: Tue, Oct 21, 1997 14:08 EDT
>Message-id: <344CEF8A.1F35_at_pacibm.org>
>
>I have a form with a trigger that calls a stored procedure.
>
>When I am connected as the dba that created the stored procedure, I have
>no problems. When I am connected as a user with EXECUTE privileges on
>the procedure, I get a compilation error at run time:
>
>"procedure_name not declared in this scope"
>
>What do I have to do in order for my users to be able to run this
>procedure?
>
>I have done:
>
>"Grant execute on dba_name.procedure_name to user_name"
>
>
>
>
>
>
>
Received on Tue Oct 21 1997 - 00:00:00 CEST