Re: Need help compiling ProC app that calls a stored procedure

You may need to compile using the option

  SQLCHECK=SEMANTICS. Try altering the makefile, for example proc16.mk supplied in the $ORACLE_HOME/proc16/samples directory.

Stored procedure calls from a PRO*C program must be compiled with this option.

If you already have this option, grant execute on the procedure to public and see if that helps.

Steve

Schubert Fernandes wrote:
>
> Hi,
>
> 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 Sat Jul 05 1997 - 00:00:00 CEST