can older tools call stored procedures?
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 78759Received on Fri Jun 16 1995 - 00:00:00 CEST