On Oct 6, 11:41 am, "R.F." <richardfor...@gmail.com> wrote:
> 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.
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;
/
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
