Results 1 to 7 of 7
  1. #1
    Join Date
    May 2007
    Posts
    11

    Question Unanswered: Unable to EXECUTE Stored Procedure

    This is the syntax I used to execute a procedure. I am using SQL devoloper

    variable r refcursor;
    variable v VARCHAR2(100);
    exec P_GET_ATRB_DTL1('1223~24314~314',:r,:v)

    There is 1 IN parameters and 3 OUT parameters of which one is of type sysrefcursor(OUT parameter).Is there any error in the syntax.

    When I am executing the procedure SQL devoloper is giving the
    error code

    ORA-00900: invalid SQL statement

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Does SQL Developer support such a syntax? Perhaps you should test it using SQL*Plus.

    Besides, if there are 3 OUT parameters, how come you don't have 3 of them in the EXEC statement?

  3. #3
    Join Date
    May 2007
    Posts
    11

    RE: Unable to EXECUTE Stored Procedure

    Besides, if there are 3 OUT parameters, how come you don't have 3 of them in the EXEC statement?

    Sorry,
    I have included that 3 parameters. Still it does'nt work . tried EXECUTE instead of EXEC . BUT still showing the same error...

    is it like SQL Devoloper not support this ...?

  4. #4
    Join Date
    Mar 2007
    Posts
    623
    Does SQL Developer support such a syntax? Perhaps you should test it using SQL*Plus.
    EXEC is SQL*Plus command, so it may not be recognised in other clients.
    Use anonymous PL/SQL block instead (BEGIN <your procedure call> END;)

  5. #5
    Join Date
    Dec 2007
    Posts
    253
    Instead of running it as a statement, run it as a script (f5 instead of f9)

  6. #6
    Join Date
    May 2007
    Posts
    11
    Thanks dude ...
    that worked...

    could you please tell me the difference in Execute (F9) and Running as a script(F5)

  7. #7
    Join Date
    Dec 2007
    Posts
    253

Posting Permissions

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