Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to use stored procedure in Pro*c

Re: how to use stored procedure in Pro*c

From: Kenneth C Stahl <BlueSax_at_Unforgetable.com>
Date: Wed, 26 Jan 2000 07:46:10 -0500
Message-ID: <388EEC92.A845D695@Unforgetable.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US