Re: Pro*C calls PL/SQL procedure....

A copy of this was sent to "LesioS" <lesios_at_box43.gnet.pl> (if that email address didn't require changing) On Thu, 25 Nov 1999 12:21:31 +0100, you wrote:

>I need some help: I have small programm written in Pro*C. I have to call a
>PL/SQL stored procedure. Within Pro*C function body I call:
>
>EXEC SQL CALL packagename.procedurename (parameters...);
>
>but my preprocessor (Pro*C 8.1.5) gives me an error (sqlcheck=semantics is
>set):
>

how about userid=u/p, have you given it enough information to log into a database as someone who can 'see' packagename.procedurename?

>PLS-S-00201, identifier 'packagename.procedurename' must be declared.
>
>What am I do in wrong way?
>
>THX in _at_vance...
> Lesio
>
>
>

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation