Hi, take local cursor, then open it, write the query inside at last assign the local cursor to the global cursor. try this i think the problem shud be solved
On Sep 25, 2:59 am, "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. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
