create type smp_emp_type as object (id number(3), name varchar2(30), gender varchar2(1)) NOT FINAL;
create table smp_emp (id number(3), name varchar2(30), gender varchar2(1)) ;
CREATE OR REPLACE procedure ins (person IN smp_emp_type) as begin Insert into smp_emp values (person); end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)