Call stored Function from SQL statement?

I have a stored function with several parameters - similar to below

/////////////////////////////////////////////////////////////////////////////////////////////////////
CREATE OR REPLACE FUNCTION sum_nums (a IN NUMBER, b IN NUMBER, c IN NUMBER) RETURN number

	IS
	BEGIN
		RETURN a+b+c;
	END;


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

Is it possible to call this from a SQL statement?

Something like -

        select * from sum_nums (1,5,7);

The parameters passed will be actual field values from a table?

Any ideas

thanks

adrian harrison Received on Mon Jan 18 1999 - 10:24:35 CST