Unable to execute SQL-Commands [message #33245] |
Mon, 23 July 2007 09:00 |
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
|
|
|
Powered by
FUDForum. Page generated in 0.02564 seconds