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 :)
Loading
waleed quwaiderPosted May 21, 2014, 3:04 PM
Jayesh DhamsaniyaPosted May 19, 2014, 4:48 AM
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;