Calling stored proc from PRO*C
Date: 1995/08/30
Message-ID: <421pcs$25f_at_hearye.mlb.semi.harris.com>#1/1
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:
Do I have to declare the procedure name in a EXEC SQL DECLARE ?
EXEC SQL EXECUTE
BEGIN
trace (:lot_nr, :fac_cd);
END;
END-EXEC;
Thanks ahead,
--
Tom Gillespie - -
Harris Semiconductor | | | |
Manufacturing Systems _/\/\/\/
Palm Bay, FL | | | |
Tom.Gillespie_at_harris.com _ _
E Pluribus UNIX
Received on Wed Aug 30 1995 - 00:00:00 CEST