3 Replies Latest reply: Dec 15, 2012 9:07 PM by vansul RSS

    Store Function note working

    973608
      hi
      i have a stored function as get_hire_date(employeeid as number) return date
      in the forms
      and i used it in the sql as
      DECLARE
      Cursor c1 is select get_hire_date(empid) from emp order by empid;
      Begin

      for k in in c1 loop
      ..
      ..
      end loop;
      end;

      but it says get_hire_Date as object not found.