Re: Pro C and Stored Procedures

Try pre-compiling with SQLCHECK=FULL. You will also need to specify the USERID=... option to the precompile command. The pre-compiler requires a connection to Oracle if it detects any PL/SQL stuff in the code.

Hope this helps,

Steve

<matthew_at_mattshouse.com> wrote in message news:731l9o$m69$1_at_nnrp1.dejanews.com...
> I have a stored procedure called 'checkopen' that I would like to execute
>from my Pro C application. It doesn't return anything, it just executes.
>I've followed the examples, but I keep getting an error when I run it
through
>the pre-compiler. Here is the code:
>
> EXEC SQL EXECUTE
> BEGIN
> checkopen(:msg,:buf);
> END;
> END-EXEC;
>
>Here is the Pro C call:
>proc SQLCHECK=SEMANTICS main.c main.pc.c
>
>Here is the error:
>PLS-S-00201, identifier 'checkopen' must be declared
>
>Where do I declare a procedure? Is this just a 'run home to mamma' error
>message?
>
>Matthew
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Nov 19 1998 - 14:40:46 CST