how to create a procedure in oracle for using as custom object in c# application

See more:

C#

Oracle

C#4.0

am passing custom object to oracle through C# application
while executing that am getting err as invalid stored procedure

i tried the below code for creating type ,table ,sp in oracle but while creating sp it throws an err procedure created with compilation error

plz help me how to create procedure for custom object...



Type:-

create type smp_emp_type as object 
 (id number(3), name varchar2(30), gender varchar2(1)) NOT FINAL;

table:

create table smp_emp 
(id number(3), name varchar2(30), gender varchar2(1)) ;

procedure:-

CREATE OR REPLACE procedure ins (person IN smp_emp_type) as
 begin
    Insert into smp_emp  values (person); 
end