Re: Using a procedure in a select statement (8.1.5i)

From: david_g <david_l_gouldNOdaSPAM_at_yahoo.com.invalid>
Date: Wed, 12 Jan 2000 06:05:10 -0800
Message-ID: <02daf294.c51a2ece@usw-ex0106-048.remarq.com>

I believe that what you need is a function:

select myfunction(var1,var2)
from dual;

You may want to do it like this:

Create Package mypackage
Is

    Function myfunction(invar1 In Number

                        ,invar2 In Number)
         Return Number;

    Pragma Restrict_References(myfunction,WNDS,WNPS); End mypackage;
Create Package Body mypackage
Is

    Function myfunction(invar1 In Number

                        ,invar2 In Number)
         Return Number
    Is
        returnvalue Number;


        ...


        your variables


        ...


    Begin


        ...


        your code


        ...


        Return(returnvalue);

    End myfunction;
End mypackage;
/

and then use
select mypackage.myfunction(var1,var2)
from dual;

                        ,

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Wed Jan 12 2000 - 08:05:10 CST