Re: calling procedures from access

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/04
Message-ID: <962685443.12911.3.pluto.d4ee154e_at_news.demon.nl>#1/1


Use begin <stored procedure name>; end;
instead of execute <stored procedure name> Actually the execute is a sql*plus wrapper.

Hth,

Sybrand Bakker, Oracle DBA

"CHUCK BECK" <ctb_at_PRODIGY.NET> wrote in message news:8jrjlc$5gkc$1_at_newssvr04-int.news.prodigy.com...
>
> Hello all,
> hope this isn't too off topic for this list.
> I am trying to create an Access application with an Oracle back end. I
 need
> Access to call some stored Oracle procedures but I do not know the syntax.
> I have tried using the SQL pass through with no success. I can pass
 regular
> SQL statements ok, but not the PL/SQL call. In Oracle you call the
> procedure with 'execute procedure name'. It does work correctly on the
> oracle side.
> Is there some kind of qualifying statement that needs to precede the
 oracle
> statement? Any ideas or places to look for info would be appreciated.
>
> Chuck
>
>
Received on Tue Jul 04 2000 - 00:00:00 CEST

Original text of this message