Re: run function of stored procedure in sqlplus
From: Andrea Cannaos <Andrea.Cannaos_at_deagostini.it>
Date: Mon, 02 Nov 1998 08:59:03 +0100
Message-ID: <363D6647.85386C70_at_deagostini.it>
Date: Mon, 02 Nov 1998 08:59:03 +0100
Message-ID: <363D6647.85386C70_at_deagostini.it>
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| | | ============================== || || (__) (__)Received on Mon Nov 02 1998 - 08:59:03 CET