Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> how to use stored procedure in Pro*c
Hi, guys,
I want to use a stored procedure in pro*c, so I use:
exec sql execute
begin
proc1(:v1,:v2);
end;
end-exec;
But when i precomplier it, got error message:SQLCHECK must be set....
So I added a line before exec sql execute:
SQLCHECK=SEMANTICS;
EXEC SQL EXECUTE
BEGIN ...