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: Desperate call for help

Re: Desperate call for help

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: 1997/04/04
Message-ID: <3345C635.21F6@exesolutions.com>#1/1

> I am still having difficulties calling a stored procedure on a oracle
> database. I have on an Personal Oracle for windows 95, a very simple
> stored procedure (it needs not input variables and it returns no rows),
> but I can't execute it from within access 95.
 

> I always receive an error message from the oracle database: invalid
> statement. Does someone know how i have to call the stored procedure
> within access. I know I have to use a passthrough query, and I do kwon
> that the EXECUTE and CALL statement don't work.

The problem may, in fact, be an invalid statement. While Oracle is ANSI SQL compliant, Access' version of SQL is some quirky Microsoft (we do it our way) variant. It is NOT real SQL. Use SQL*Plus to test your SQL statements and make sure they really are SQL.

Daniel A. Morgan Received on Fri Apr 04 1997 - 00:00:00 CST

Original text of this message

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