Calling Stored Procedures from FOrms (Again)

From: Peter W. Flur <flur_at_tokyo.eecom.gatech.edu>
Date: Sun, 9 Jan 1994 21:34:00 GMT
Message-ID: <1994Jan9.213400.28055_at_ee.gatech.edu>


I am still having problems calling a stored procedure from SQLFORMS30. I have looked at all the stuff in the manuals, and I have upgraded to the latest release, yet I still can't call a stored procedure.

Here is the stored procedure:
create procedure xyz (a number) is

        rows number;
begin
  rows := 1;
end xyz;

It compiled fined, and I can run it from sqlplus.

Here is the code in my form which attempts to call it:

   DEFINE PROCEDURE

      NAME = calc_balances
      DEFINITION = <<<
      procedure calc_balances is
      begin
	xyz(1);
      end;

>>>

   ENDDEFINE PROCEDURE And here is what is produced by generate30:

Compiling CALC_BALANCES procedure on form... PL/SQL error 313 at line 3, column 1:

   'XYZ' not declared in this scope
   Statement ignored
FRM-30137: Compile Error on procedure CALC_BALANCES. Compiling CHECK_PACKAGE_FAILURE procedure on form...

    No compilation errors.

I've modified it to try ops$flur.xyz, and it returns the same error.

Forms30 Release:

SQL*Forms Design: Release 3.0.16.12.7 - Production                     
Using Oracle Toolkit Version 01.00.20.03.01 (Production)           
Using PL/SQL Version 01.00.39.00.01 (Production)                  
Using SQL*Menu Version 05.00.11.13.05 (Production)               

RDBMS Release:
SQL*Plus: Release 3.1.2.3.1 - Production on Sun Jan 9 15:54:31 1994 ORACLE7 Server Release 7.0.15.4.0 - Production With the procedural option
PL/SQL Release 2.0.17.1.0 - Production

Thanks for any help you can give me.

Peter

-- 
-----------------------------------------------------------------------
     Peter Flur, Research Engineer - School of ECE, Georgia Tech
       E-MAIL: peter.flur_at_ee.gatech.edu PHONE: (404) 853-9355
     DUKE UNIVERSITY -- 1991 & 1992 NCAA BASKETBALL CHAMPIONS!!!
Received on Sun Jan 09 1994 - 22:34:00 CET

Original text of this message