Thanks for your help. I was able to solve the problem. On Thu, Sep 24, 2009 at 8:34 PM, Michael Moore <michaeljmo...@gmail.com>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 <richardfor...@gmail.com>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 <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> >> 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 -~----------~----~----~----~------~----~------~--~---
