Re: ODBC & SQL pass through
Date: Thu, 29 Dec 1994 13:55:41 +0000
Message-ID: <336301965wnr_at_rtel.demon.co.uk>
In article: <ewehrli.788538237_at_scorpion.cowan.edu.au> ewehrli_at_scorpion.cowan.edu.au (Edward
WEHRLI) writes:
>
> Hi everybody,
>
> I need to use the SQL pass-through option from MS-Access. The reason:
> to call stored procedures in the Ora DB. However, I always get an ORA
> 00900 error (incorrect SQL syntax). As far as I know I used every possible
> combination, i.e. only sending an execute <procedure>, embedding the command
> into PL/SQL block, even embedding the command into an exec sql block but
> to no avail.
> I really appreciate any help which would shed some light onto this.
the EXECUTE command is a SQL*Plus command. You will have to create an anonymous PL/SQL block thus;
BEGIN;
<procedure>;
END;
Stephen Lappin
Received on Thu Dec 29 1994 - 14:55:41 CET