Menu

#74 ORA-00900 on stored procedure creation with ';'

open
nobody
None
5
2004-03-19
2004-03-19
Anonymous
No

First of all, great job on the plugin!
I kept getting "ORA-00900: Invalid SQL Statement" when
running a stored procedure creation script from the SQL
Editor. The script worked fine in the SQL Worksheet
though. Other scripts, with multiple "CREATE TABLE"
statements in them, worked fine in both. The problem
turned out to be in the semicolons between the PL/SQL
statements in the stored procedure body. When I
replaced ';' with '/', the script worked fine in the
SQL Editor, however, SQL Worksheet refused it.
I am using JFaceDbc 2.2.1, Eclipse 2.1.2 and Oracle 9i.

Discussion


Log in to post a comment.