Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Unable to execute SQL-Commands
Unable to execute SQL-Commands [message #33245] Mon, 23 July 2007 09:00
Florian Reiser is currently offline Florian Reiser
Messages: 25
Registered: July 2009
Junior Member
Hello,

I'm trying to create a simple stored procedure via SQL on my Oracle DB.
When executing the following SQL with the Oracle extension from
http://www.oracle.com/technology/tech/eclipse/dtp/files/gett ingstarted.html
activated to create the dummy function the following error occurs:

SQL:

CREATE OR REPLACE PROCEDURE TEST_PROC () AS
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
END TEST_PROC;

Error with Oracle extension:

CREATE OR REPLACE PROCEDURE TEST_PROC () AS
BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
END T
END TEST_PROC;


ORA-00900: Ung├╝ltige SQL-Anweisung

Why is this additional line "END T" inserted?

When I deactivate this extension and to the same statement again, I get
the following error:

BEGIN
DBMS_OUTPUT.PUT_LINE('Test');
END
TEST_PROC



ORA-06550: Zeile 1, Spalte 6:
PLS-00103: Fand das Symbol "" als eines der folgenden erwartet wurde:

begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
Das Symbol "" wurde ignoriert.
ORA-06550: Zeile 2, Spalte 31:
PLS-00103: Fand das Symbol "" als eines der folgenden erwartet wurde:

begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identi

Now the line containing the CREATE OR REPLACE PROCEDURE ... statement is
simply ignored.

Why is this statement not transfered to the DB-Server as a whole?


With kind regards
Florian Reiser
Previous Topic:DB2 zSeries
Next Topic:Unable to execute SQL-Commands
Goto Forum:
  


Current Time: Mon Oct 20 21:18:13 GMT 2014

Powered by FUDForum. Page generated in 0.02427 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software