Re: Help Calling Stored Procedure from Forms30

In article <129276_at_hydra.gatech.EDU>, gt2500a_at_prism.gatech.EDU (Peter Wade Flur) wrote:

>
> I believe that I have followed all the instructions in storing a procedure
> called calculate_it with one parameter (account varchar2). I can then
> call the procedure fine from sqlplus. However, when I call it from
> Forms30, I get the following message:
>
> PL/SQL error 313 at line 3, column 1:
> 'CALCULATE_IT' not declared in this scope
> Statement ignored
> FRM-30137: Compile Error on procedure CALC_BALANCES.
>
>
> This is:
> SQL*Forms (Generate): Release 3.0.16.12.3 - Production
> Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
> Using PL/SQL Version 01.00.36.02.02 (Production)
>
> With:
> Connected to:
> ORACLE7 Server Release 7.0.12.1.0 - Production
> With the procedural option
> PL/SQL Release 2.0.14.0.1 - Production
>
>
> I also have execute priveledges and there is also a public synonym for the
> procedure name defined.
>
> Can anyone help?
> Thanks
> Peter

Check the Oracle7 Server Application Developer's Guide pages C2-C5. It describes several reasons that you might get a "not declared in this scope". We execute Oracle7 stored procedures in Forms30 and Forms40 and they seem to work OK. When we have got the "not declared in this scope" message it has been related to data typeing or grants.

-- 
==============================================================================
Dave Erwin
Lockheed Missiles & Space Company
Email: erwin_at_lmsc.lockheed.com