Access and Oracle stored procedures

From: Larry MacNeill <Larry.MacNeill_at_uchsc.edu>
Date: Mon, 22 Jan 2001 13:15:57 -0700
Message-ID: <94i4cq$f6g$1@Crestone.UCHSC.edu>

How do you run a stored procedure and a function using Access 2000 and ODBC? Access 97 information would be useful, too. What is the Procedural Option referred to in the error message below? I have looked at the master index but do not see it. I do not see the PL/SQL banner when I start SQL*Plus.

Are there any books that

I tried this.
create or replace procedure sp_commit
begin

      commit;
  end;
Then I created a pass-through SQL query using Access with this text.   execute sp_commit;
The error message is
  [Oracle][Oracle ODBC Driver][Oracle (#900)

From the documentation,

ORA-00900 invalid SQL statement

Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed. Action: Correct the syntax or install the Procedural Option.

Any clues are welcome. Thanks. Received on Mon Jan 22 2001 - 14:15:57 CST