Re: Calling stored proc from PRO*C
Date: 1995/08/31
Message-ID: <424nd5$r2_at_babbage.ece.uc.edu>#1/1
In article <421pcs$25f_at_hearye.mlb.semi.harris.com>,
Tom Gillespie <tgillesp_at_ms13.mis.semi.harris.com> wrote:
>I need some advice on calling a stored PL/SQL procedure from
>a Pro*C program. I have a stored procedure called "trace"
>that I can run from SQL*Plus using the EXECUTE command.
>But when I try to execute it from an embedded C program,
>I get "PCC-S-02313, 'TRACE' not declared in this scope".
>Here is how I'm calling it from the C program:
>
> EXEC SQL EXECUTE
> BEGIN
> trace (:lot_nr, :fac_cd);
> END;
> END-EXEC;
>
>Do I have to declare the procedure name in a EXEC SQL DECLARE ?
There is a bug in Pro*C (dont know which ver).
The simplest solution is to use the login/password of owner of
package/procedure during compilation.
ie. if XXX is the actual owner of the package use XXX/password during
compilation.
>
>Thanks ahead,
>--
> Tom Gillespie - -
> Harris Semiconductor | | | |
> Manufacturing Systems _/\/\/\/
> Palm Bay, FL | | | |
> Tom.Gillespie_at_harris.com _ _
>
> E Pluribus UNIX
Received on Thu Aug 31 1995 - 00:00:00 CEST