I had to create the package and body separately. Here is an example:
create or replace
package otn_ref_cursor as
-- used to illustrate passing a ref cursor
-- as a return value from a function
-- or as an output parameter from a procedure
procedure get_emp_info(emp_name IN varchar2,p_rc out sys_refcursor);
end;
///////////
create or replace package body otn_ref_cursor as
procedure get_emp_info(emp_name IN VARCHAR2, p_rc out sys_refcursor) is
begin
-- open the cursor using the passed in ref cursor
-- sys_refcursor is a built in type
open p_rc for
select employee_id,
first_name,
last_name
hire_date
from employees
where last_name Like upper(emp_name)||'%';
end;
end;
Hope this helps.
On Thu, Oct 15, 2009 at 1:59 AM, niraj <[email protected]> wrote:
>
> Could you please send me the solution through which u'd solved your
> problem
>
> On Sep 26, 10:41 pm, Richard Ford <[email protected]> wrote:
> > Thanks for your help. I was able to solve the problem.
> >
> > On Thu, Sep 24, 2009 at 8:34 PM, Michael Moore <[email protected]
> >wrote:
> >
> >
> >
> > > I'm not sure I solved your problem since I was unable to replicate the
> > > problem.
> > > Mike
> >
> > > On Thu, Sep 24, 2009 at 5:16 PM, Richard Ford <[email protected]
> >wrote:
> >
> > >> Thank you. I am a newbie to Oracle ,coming from a SQL server
> background.
> >
> > >> Regards,
> > >> Richard
> >
> > >> On Sep 24, 2009, at 6:00 PM, Michael Moore <[email protected]>
> > >> wrote:
> >
> > >> can you post the entire package spec as well as the body?
> > >> also try this:
> >
> > >> CREATE OR REPLACE PACKAGE BODY select_job_history
> > >> AS
> > >> TYPE t_cursor IS REF CURSOR;
> >
> > >> PROCEDURE getjobhistorybyemployeeid(
> > >> p_employee_id IN NUMBER,
> > >> cur_jobhistory OUT t_cursor )
> > >> IS
> > >> BEGIN
> > >> OPEN cur_jobhistory FOR
> > >> SELECT *
> > >> FROM employees
> > >> WHERE employee_id = p_employee_id;
> > >> END getjobhistorybyemployeeid;
> > >> END select_job_history;
> > >> /
> >
> > >> On Thu, Sep 24, 2009 at 2:59 PM, R.F. < <[email protected]>
> > >> [email protected]> wrote:
> >
> > >>> Hello,
> > >>> Can someone help me get this to compile. I get the ERROR at line 9:
> > >>> PLS-00103: Encountered the symbol "BEGIN" when expecting one of the
> > >>> following:
> >
> > >>> language
> > >>> 7. )
> > >>> 8. IS
> > >>> 9. BEGIN
> > >>> 10. OPEN cur_JobHistory FOR
> > >>> 11. SELECT * FROM employees
> >
> > >>> CREATE OR REPLACE PACKAGE BODY SELECT_JOB_HISTORY AS TYPE T_CURSOR IS
> > >>> REF CURSOR ;
> > >>> PROCEDURE GetJobHistoryByEmployeeId
> > >>> (
> > >>> p_employee_id IN NUMBER,
> > >>> cur_JobHistory OUT T_CURSOR
> > >>> )
> > >>> IS
> > >>> BEGIN
> > >>> OPEN cur_JobHistory FOR
> > >>> SELECT * FROM employees
> > >>> WHERE employee_id = p_employee_id;
> > >>> END GetJobHistoryByEmployeeId;
> > >>> END SELECT_JOB_HISTORY;
> >
> > >>> Thanks in advance.
> >
> > --
> > Regards,
> >
> > Richard Ford
>
> >
>
--
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 [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
-~----------~----~----~----~------~----~------~--~---
