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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
