Re: stored procedure in pro*c

Try adding SQLCHECK=FULL|SEMANTICS to the PROC command in the makefile (or your proc command) NOT in the C program (FULL is the same as SEMANTICS!).

ie proc INAME=whatever.pc ONAME=whatever.c USERID=user/pass SQLCHECK=FULL etc. etc.

You should also check sqlerrm after the end-exec as if the stored procedure doesn't run/work you will not know unless you check sqlerrm (if I remember rightly the value 0 mean succesful completion!!)

HTH Bob

Calvin Ni <haitao_at_yesic.com> wrote in message news:388E5CA5.A58BBBB0_at_yesic.com...
>
> 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
>
Received on Wed Jan 26 2000 - 15:03:27 CET