This content has been marked as final. Show 3 replies
Use function instead of procedure to return a value.
how to execute functions in oracle 11g
If you have a function called get_id
Declare v_id number; begin v_id := get_id ; end;
Check this link http://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25108/xedev_programs.htm#BABBJDGF
Select get_id from dual;