Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    39

    Unanswered: invalid sql statement

    Hi,
    I am trying to run a sql statement to execute a procedure in oracle.
    I am used to sql server and this is my first time using oracle.
    This is what I am running and it gives the error: invalid sql statement.
    Any thoughts please?
    EXECUTE RES_DEV.PH.UDFExist('COM_X');

    I have tried takiing out the semi colon at the end and even tried exec instead of execute...
    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    "UEFEXIST" is stored procedure, right? Is it owned by you? If so, you don't need to precede procedure's name with schema name (which is, I guess, "RES_DEV").

    What does "PH" mean here? Is it a package name?

    Here is a short example; check it and see what might be wrong in your case:
    Code:
    SQL> create or replace procedure uefexist(par_name in char) is
      2  begin
      3    dbms_output.put_line('Hello, ' || par_name);
      4  end;
      5  /
    
    Procedure created.
    
    SQL> set serveroutput on
    SQL> execute uefexist('Littlefoot');
    Hello, Littlefoot
    
    PL/SQL procedure successfully completed.
    
    SQL>

  3. #3
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    How are you running this? EXEC[UTE] is a SQL*Plus command. Are you using SQL*Plus?

    CALL is the equivalent SQL command.

Posting Permissions

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