Re: Help !!! I can't call a store procedure from a form trigger
Date: 1996/07/31
Message-ID: <31FFE5E4.F9E_at_erudite.com>#1/1
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.
>
> Thank you in advance.
> my e-mail address is joe.kau_at_lmco.com
First, Forms Designer must be connected to the database. It automatically prompts you to connect under most circumstances, but if you haven't done anything except code a form trigger that accesses a stored procedure it may not be connected to the database. If you are not connected, Forms will not be able to see any stored procedures.
Second, if the stored procedure is in a package, make sure that you qualify the procedure name with the package name.
Those are my first two thoughts.
I hope this helps,
Shawn
Received on Wed Jul 31 1996 - 00:00:00 CEST