PL SQL Program For to insert records using procedures.

PL SQL Program For to insert records using procedures 


create or replace package body prcpack is 
procedure ins(no in number,nam in varchar2) is 
begin 
insert into employ values(no,nam);
dbms_output.put_line(' Record inserted successfully');
end ins;
procedure delt(no in number) IS
begin
delete from employ where empid=no;
dbms_output.put_line(' Record '||no||' deleted succesfullly');
end delt;
procedure updat(no in number,nam varchar2) IS
begin
update employ set empname=nam where empid=no; 
dbms_output.put_line(' Record '||no||' updated succesfullly');
end updat;
end;