Need help compiling ProC app that calls a stored procedure
Date: 1997/07/04
Message-ID: <01bc887c$49d74c20$52247aa3_at_L1182.tulbom.unisys.com>#1/1
Hi,
[Quoted] I am having trouble compiling a ProC application that calls a stored procedure. The relevant snippet of my code looks like this...
EXEC SQL EXECUTE
BEGIN sp1.sp_try(:mydno); END; END-EXEC;
The package sp1 and the procedure sp_try were created successfully using
SQL*Plus.
The error message is as follows...
Precompiling sp1.pc
58 END-EXEC;
58 ........^
PCC-S-0061: Error at line 59, column 26. PLS-201: identifier
'SP1.SP_TRY'
must be declared
58 END-EXEC;
58 ........^
PCC-S-0061: Error at line 59, column 22. PLS-0: Statement ignored
I am using Pro*C: Release 1.5.9.0.1
I even tried compiling the sample applications that came with my Oracle
package but these do not compile either. The error message returned is the
same. I have a feeling I'm doing something really foolish with some kinda
environmental setting, sp please help. Please post replies to this
newsgroup or to <schubert_at_tulbom.unisys.com>
TIA. Schubert. Received on Fri Jul 04 1997 - 00:00:00 CEST