Re: Call stored Function from SQL statement?

From: victor <victor_at_PERCOMBANK.KIEV.UA>
Date: 21 Jan 1999 10:56:32 GMT
Message-ID: <01be452c$71ae52c0$cd14abcc@victor>

create package a as
FUNCTION sum_nums (a IN NUMBER, b IN NUMBER, c IN NUMBER) RETURN number;  PRAGMA RESTRICT_REFERENCES(sum_nums ,WNDS,WNPS); end;

create package body a as

////////////////////////////////////////////////////////////////////////////
/////////////////////////

> CREATE OR REPLACE FUNCTION sum_nums (a IN NUMBER, b IN NUMBER, c IN
NUMBER) RETURN number
> IS
> BEGIN
> RETURN a+b+c;
> END;
>

////////////////////////////////////////////////////////////////////////////
/////////////////////////

>

end;

select a.sum_nums (col1,col2,clo3) from tablename; Received on Thu Jan 21 1999 - 04:56:32 CST