Re: Help !!! I can't call a store procedure from a form trigger

Joe wrote:
>
> Hi,
>
> i tried to call a store procedure within a form trigger and I got a
> compile error. It indicated that the stroe procedure must be declared.
>
> It seems that the form can't see the store procedure.
> I am running form 4.5 under Oracle 7.2.3.

U must be connected to the oracle DB in order to compile your trigger . Check that U are connected with a user that has execute privilages on the procedure .
Finally check the way U call the stored procedure : is it a function or procedure , what parameters does it takes etc ..

-- 
++++++++++++++++++++++++++++++++++	|\/\/\|
 Shay Shmelzer				|     |
 E-mail : shmelzer_at_johnbryce.co.il	OO    )
 Phone  : 972-3-5765647	ISRAEL		c     |
 Organization: John Bryce Systems	/___/ |
++++++++++++++++++++++++++++++++++	   )  (