Hi All

How to execute a FUNCTION on SQL prompt. I know about using the command 'variable ' and then assigning output to it. But I dont know how to assign returning value of a function to it.
I have done

variable i number
i := exec reval(2);
print i

This does not work but ....

If I execute it in begin ... end block it shows proper out put.

What is the way I can see output in variable i.

Amol