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

From: Shawn Odekirk <shawno_at_erudite.com>
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

Original text of this message