Re: Executing a Oracle Stored Procedure

This will help

SQL> execute myfunction('myvarcharvariable');

Value cannot be printed to screen without any PLSQL package. You can use a dummy table instead to store the results.

Muhammad Ahmad Malik
Western Michigan University
mamalik_at_cs.wmich.edu - http://www.wmich.edu/frc/ahmad.html +1 (616) 373-3065

On Tue, 29 Oct 1996, John Bush wrote:

> 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:
>
Received on Wed Oct 30 1996 - 00:00:00 CET