executing function on SQL prompt

[amolik]

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

[abhaysk]

Originally posted by amolik
Hi All

print i

Amol

Print???

this seems to be SQL Server command....rather than oracle...

[pando]

lsc@DEV817-ES7J2BKT8ZM0YY>create or replace function mynumber
  2  return number
  3  as
  4    l_number number;
  5  begin
  6    select 1
  7      into l_number
  8      from dual;
  9    return l_number;
 10  end;
 11  /

Function created.

lsc@DEV817-ES7J2BKT8ZM0YY>variable x number
lsc@DEV817-ES7J2BKT8ZM0YY>exec :x:=mynumber

PL/SQL procedure successfully completed.

lsc@DEV817-ES7J2BKT8ZM0YY>print x

         X
----------
         1

[jmodic]

Originally posted by abhaysk
Print???

this seems to be SQL Server command....rather than oracle...

SQL*Plus reference manual is a good reading sometimes......

[abhaysk]

Originally posted by jmodic
SQL*Plus reference manual is a good reading sometimes......

I shud start i think...

[ales]

select reval(2) from dual;