Thank you. On Tue, Oct 6, 2009 at 3:41 PM, ddf <orat...@msn.com> wrote:
> > > > 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 > > > -- Regards, Richard Ford --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
