+ Reply to Thread
Results 1 to 3 of 3

How to execute Oracle stored procedures within Squirrel SQL ?

  1. How to execute Oracle stored procedures within Squirrel SQL ?

    Hi all

    How to execute Oracle stored procedures from within Squirrel SQL.

    I know "exec " works in SQL Plus.

    Thanks
    Steve


  2. Re: How to execute Oracle stored procedures within Squirrel SQL ?


    "stonecoldsteve" wrote in message
    news:1135709390.008154.264630@g43g2000cwa.googlegroups.com...
    > Hi all
    >
    > How to execute Oracle stored procedures from within Squirrel SQL.
    >
    > I know "exec " works in SQL Plus.
    >
    > Thanks
    > Steve
    >


    don't know what Squirrel SQL is, but...

    'exec' is a SQL*Plus command which is a shortcut for an anonymous
    procedure -- that's why error messages (unhandled exceptions) look like
    this:

    SQL> exec some_procedure
    BEGIN some_procedure; END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'SOME_PROCEDURE' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    the actual syntax to execute a stored procedure from any environment that
    can pass SQL to the database is usually to wrap the stored procedure call in
    an anonymous block, aka:

    BEGIN some_procedure; END;

    ++ mcs



  3. Re: How to execute Oracle stored procedures within Squirrel SQL ?

    Hi all.

    In SquirrelSQL I can execute an Stored Procedure in this way:

    call SP_NAME (PARAM1, PARAM2, ...)

+ Reply to Thread