In order to call a stored procedure from within a Pro*C program, you must
use an anonymous PL/SQL block in your program (e.g.)
EXEC SQL EXECUTE
Additionally, in your makefile (proc.mk), you must specify SQLCHECK=FULL,
or SQLCHECK=SEMANTICS. When doing this, you must also specify USERID in
Hope this helps.
> I am trying to call a stored oracle procedure in a Pro*C program. If I
> call it using exec sql procedure_name(param,param), I don't get any
> compile errors but I don't appear to be executing the procedure. If I
> try calling the procedure as an embedded PL/SQL block, I get sqlcheck
> errors which I am unfamiliar with.
> Can anyone help with this?
> Susan Loguidice
> Southern Oregon State College