Calling Stored Procedures from FOrms (Again)
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