Gunas,
In order to use user defined function in SQL stmt u need to define the Pragma Restrict referrence in u r function.

--Sriram.