Re: Pro*C compiler error calling stored function

Try this :

EXEC SQL SELECT myfunc(:myparam) INTO :myreturn FROM DUAL;

Regards

EA <appshome_at_geocities.com> a écrit dans l'article <85icbk$8fs$1_at_pollux.ip-plus.net>...
> The Oracle Pro*C precompiler (Pro*C/C++: Release 8.0.4.0.0 on Sun Solaris
> 2.6) doesn't seem to like the following syntax for calling a stored
> function:
>
> EXEC SQL CALL myfunc(:myparam) INTO :myreturn;
>
> The error message is
>
> PCC-S-02201, Encountered the symbol "CALL" when expecting one of the
> following:
>
> for, at, close, commit, connect, declare, describe, execute,
> fetch, open, prepare, rollback, select, whenever, alter,
> audit, comment, create, delete, drop, grant, insert, lock,
> noaudit, rename, revoke, set, update, validate, arraylen,
> allocate, cache, context, enable, free, object, savepoint,
> analyze, explain, truncate,
> The symbol "alter," was substituted for "CALL" to continue.
>
> According to the manuals (I only have Oracle 8i manuals at hand but I
don't
> suppose this has changed from release 8.0x to release 8.1x) this syntax
> should be just fine.
>
> After the precompiler substitutes "alter" for "CALL" everything goes
> downhill, of course, with follow up errors like
>
> PCC-S-02206, Host variables are not permitted within a DDL statement
>
> Any ideas what I'm doing wrong? To reproduce this behaviour just add the
> offending line plus some host variable declarations to sample1.pc that
comes
> with Pro*C.
>
> Any help would be greatly appreciated.
>
> Cheers
> E.
>
>
>
>
>
>
>
Received on Fri Jan 14 2000 - 16:58:42 CET