Results 1 to 6 of 6

Thread: Strange Problem

  1. #1
    Aseem is offline Senior Member
    Join Date
    Mar 2009
    Location
    USA
    Posts
    127
    Rep Power
    0

    Default Strange Problem

    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..!

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,015
    Rep Power
    20

    Default

    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?

  3. #3
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    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.

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,015
    Rep Power
    20

    Default

    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.

  5. #5
    Aseem is offline Senior Member
    Join Date
    Mar 2009
    Location
    USA
    Posts
    127
    Rep Power
    0

    Default

    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.

  6. #6
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,015
    Rep Power
    20

    Default

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

Similar Threads

  1. Strange JSTL recordset result problem (Question)
    By jeremy.wilson in forum JavaServer Pages (JSP) and JSTL
    Replies: 6
    Last Post: 01-07-2010, 06:04 PM
  2. strange swt exception
    By ahmed.kotb in forum SWT / JFace
    Replies: 0
    Last Post: 04-23-2009, 10:15 AM
  3. Replies: 0
    Last Post: 03-04-2009, 09:51 AM
  4. Strange problem
    By Tamir in forum Eclipse
    Replies: 1
    Last Post: 08-18-2008, 09:44 PM
  5. What is the answer to this strange problem:
    By willemjav in forum New To Java
    Replies: 5
    Last Post: 08-11-2008, 09:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •