Re: run function of stored procedure in sqlplus

NGAN wrote:

> How can I execute a function of sotroed procedure in sqlplus? I need
> to
> know the command. Thank you.

Use execute command :

assuming your function return a varchar2 value :

SQL> Var a varchar2(2000);

SQL> execute :a := my_funct(par1,par2...);

SQL> print a;

--
           \\\\////
           &( oo )&
========oOO==(__)==OOo========
|                            |
|Andrea.Cannaos_at_deagostini.it|
|                            |
==============================
            ||   ||
           (__) (__)