Strange Problem

[Aseem]

Is anyone here using OracleExpress10g edition for stored procedures.
You can't execute stored procedure in expression edition for some reasons.
runs well in SQL*plus.

CREATE OR REPLACE PROCEDURE Test
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('Test!');
END;

EXEC Test;

Doesnt execute. throws error
ORA-00900: invalid SQL statement

WTF?

any suggestions..!

[Tolls]

As far as I am aware the restrictions on express are a single external connection, and some db size limitation of a few Gb.

Be a bit useless if you couldn't run SPs...

Oh, and this has nothing to do with Java, does it?

[masijade]

SQL*Plus has it's own language extensions over and above the SQL normally available, even in Oracle itself, and those extensions cannot, AFAIK, be used in a JDBC Statement. And, I believe that DBMS_OUTPUT stuff is one of those.

[Tolls]

Ohhhhh!
You're calling "EXEC Test" as some JDBC call?

Oh yes, you can't do that.

ETA: The create or replace should work. DBMS_OUTPUT is a valid PL/SQL package in all Oracle versions, at least as far back as anyone should have to go. JDBC won't care.

[Aseem]

NO...got nuthing to do with JDBC. Just a simple StoredProc trying to execute on ORacleXE.
I heard before it doesnt work...tried it...didnt work. So, i think it doesnt work.

[Tolls]

So, and this may be a silly question, why not ask at the actual Oracle forums?
They're really quite good over there.