Need help compiling ProC app that calls a stored procedure

From: Schubert Fernandes <schubert_at_tulbom.unisys.com>
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

Original text of this message