Re: Stored Procedures and Forms 4.5

In article <DMD8uG.7qK_at_newshost.atk.com>, "Dennis Currit_at_atk.com" <Dennis_Currit> writes:
|>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.
|>
|>
Are you sure synonyms are correctly set?

-- 
With best regards,
	Harri
-----------------------------------------------------------------------
(Opinions stated above are mine, not Oracle Corporation's)
Oracle Corporation
Harri Kaukovuo,  Applications Engineer		Tel.	+1-415-506 3258
500 Oracle Parkway, P.O.Box 659304		Fax	+1-415-506 7292
REDWOOD SHORES, CA 94065, USA			hkaukovu_at_us.oracle.com