Re: Calling stored proc from PRO*C

In article <421pcs$25f_at_hearye.mlb.semi.harris.com>, tgillesp_at_ms13.mis.semi.harris.com (Tom Gillespie) writes:
|> 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 ?
|>
|> Thanks ahead,
|> --
|> Tom Gillespie - -
|> Harris Semiconductor | | | |
|> Manufacturing Systems _/\/\/\/
|> Palm Bay, FL | | | |
|> Tom.Gillespie_at_harris.com _ _
|>
|> E Pluribus UNIX
No, but you do need the USERID precompiler option. Received on Thu Aug 31 1995 - 00:00:00 CEST