waleed quwaider

waleed quwaider

  • NA
  • 3
  • 1.3k

problem with procedures ( select query and cursors ) Oracle

May 16 2014 7:52 PM
hello,
" am using oracle 11g " 
am connecting my asp.net project with oracle database , so am creating Procedures to get my 
work perfect.
this is the code am using to create procedure  
create or replace package humanresources
type t_cursor is ref cursor;
as
procedure get_employee(cur_employees out t_cursor)
is
begin
open cur_employees for select * from emp;
end get_employee;
end human_resources;
and the error in the first line at column 7 so it's near create
i don't know why i am getting this error ...
thanks in advance :) 


Answers (2)