Call stored Function from SQL statement?

Sorry if this message appears twice but good old Globalnets news server has crashed again!!!!!!!!!!

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 Tue Jan 19 1999 - 05:45:07 CST