Re: Stored Procedures and Forms 4.5

From: Lee Levy <levy.lee.ls_at_bhp.com.au>
Date: 1996/02/07
Message-ID: <4fbc98$h3u_at_gossamer.itmel.bhp.com.au>#1/1

In article <DMD8uG.7qK_at_newshost.atk.com>, "Dennis Currit_at_atk.com" <Dennis_Currit> says:
>
>I am having trouble accessing a stored procedure from a trigger in Forms
>4.5. It works fine for the owner of the procedure, but doesn't work for
>other users. These users have "execute" privelege for the procedure.
>Moreover, they can execute the procedure from sqlplus. I think the
>problem is that I don't know how to qualify the procedure name. If I
>create the form using the userid of the owner of the procedure and don't
>qualify the procedure name, it compiles the trigger and generates the
>form. If I run the form using any other user id, it gets an ORA-06550
>error. If I create the form using any other user id, it will not compile
>the trigger, no matter how I qualify the procedure name. Any help would
>be appreciated. Thanks.
>

I dont know too much about these things, but I think you need to create a synonym so the other users can see the SDP without a qualifier

HIH
Lee

------/\/\------+---------------------------------------------------
     / / /\     |  Lee Levy, ISSD Systems Development, Del Code (34)
    / / /  \    |  BHP Information Technology,  ACN 006 476 213
   / / / /\ \   |  PO Box 261, Warrawong, NSW 2502, Australia

   \ \/ / / / | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-     \ / / / | Internet : levy.lee.ls_at_bhp.com.au

-----\/\/\/-----+---------------------------------------------------

Opinions expressed are mostly my own, so give me some credit. Received on Wed Feb 07 1996 - 00:00:00 CET