Re: Executing a Oracle Stored Procedure

  For stored procedures development task I can recommend you evaluate SQL*Minus program. This solves all problem you describe in convinient way. 1. It have procedure execution terminal where you can select procedure name to execute from combobox, enter values for input parameters in grid ( PL/SQL tables supported) execute and see values of output parameters in grid.
2. You can use DBMS_OUTPUT.put_line procedure to implement tracing facility, results are catched by DBMS_OUTPUT window of SQL*Minus. 3. You can generate you PL/SQL scripts from SQL*Minus and get immediate access to compilation error in point and click style.

So this is utility written specially for such tasks. ( and it installation will not trouble you, if you have 32-bit SQL*Plus already running, no more action required just start sqlminus.exe)

Regards, Victor Poteryahin.

John Bush <jbush_at_netbox.com> wrote in article <3276A054.49A7_at_netbox.com>...
> I have created an oracle stored procedure,
>
> I would like to execute the procedure from sqlplus
>
> Unfortunately the docs dont give a descent example of how to to this
> with an out parm. Here is what I have, but it doesnt seem to work:
>
> It would also be nice to display the value of TEST to the screen!
>
> thanks in advance
>
> -John
>
  Received on Thu Oct 31 1996 - 00:00:00 CET