Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how to use stored procedure in Pro*c
Calvin Ni wrote:
>
> 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
> ...
> And I got the same message too.
> Any idea? Thanks in advance.
> Calvin
Tje SQLCHECK=SEMANTICS is a parameter to proc. Include it in your PROCFLAGS in the makefile. You may also need to add the USERID parameter. Received on Wed Jan 26 2000 - 06:46:10 CST
![]() |
![]() |