That did not seem to work. This is the entire package body. I'm trying to start with returning a result set from Oracle using asp.net/ODP.net
On Thu, Sep 24, 2009 at 8:00 PM, Michael Moore <michaeljmo...@gmail.com>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. <richardfor...@gmail.com> 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
