How can i call pl/sql stored procedure (function, returning number value)?

Question

Hi,

I'm using oracle sql developer, or oracle sqlplus.

Thank,

Mattan

Answer 1

In SQL Plus you can do this:

var x number
exec :x := myfunction();

Or you may be able to use SQL:

select myfunction() from dual;