Printable View
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..!
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?
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.
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.
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.
So, and this may be a silly question, why not ask at the actual Oracle forums?
They're really quite good over there.