Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Access and Oracle stored procedures
> 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.
>
Excuse me for not being able to answer your question but I am intrigued. Why would you want to? Oracle is the post powerful relational database around and you are trying to front-end it with one of the clunkiest examples of a database I have seen since before dBASE III+.
Why don't you get Oracle's Discoverer if you are doing reports or Developer Forms if you are doing data entry?
Daniel A. Morgan Received on Mon Jan 22 2001 - 21:32:32 CST