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
I've had the same problems a few month ago (Oracle 7).
In this case I've done a
SQLCHECK=FULL
and
USERID=USER/PASSWORT
You must run PROC with connecting to a database with the stored
procedure.
Then it works
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
--
![]() |
![]() |