can older tools call stored procedures?

From: David Elliott <dae_at_pencom.com>
Date: 1995/06/16
Message-ID: <NEWTNews.803323100.26850.dae_at_redwood.pencom.com>#1/1


Hi,

A customer is running Oracle 7.0.16.6.5 on a Netware server, but they are still using old, DOS-based tools on the client machines (SQL*Plus: Version 3.0.9.1.1 and SQL*Forms: Version 3.0.16.3.2). I've created a package with several stored procedures (using sql*dba). That seemed to work, but when I issue the "execute" command from sql*plus, I get the error: unknown command beginning "execute de..." - rest of line ignored.

And from within sql*forms, I also get compile errors such as:  PL/SQL error 303 at line 25, column 1:

    qualifier 'PREMIUM_CALC' must be declared

Is the problem that I'm using tools that just can't deal with stored procedures? BTW, I have granted execute to public and created a public synonym for the package. I also tried creating a public synonym for a particulare procedure in the package and got similar results.

Thanks in advance for any help,

David Elliott		        Sr. Software Eng.	email:  dae_at_pencom.com
Pencom Software		        main:   (512)-343-6666
9050 Capitol of TX Hwy N.	FAX:    (512)-343-9650
Austin, TX 78759             
Received on Fri Jun 16 1995 - 00:00:00 CEST

Original text of this message