Hello ,
I have a procedure in a package... Heres the procedure:
create or replace package body otn_ref_cursor as
procedure get_emp_info(emp_id IN NUMBER, p_rc out sys_refcursor) is
begin
open p_rc for
select employee_id,
first_name,
last_name,
hire_date
from employees
where employee_id Like'emp_id%';
end;
end;
I am unable to retreieve results using the "LIKE" keyword, any
suggestions? Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
