Implementing procedures using parameters

Procedure for deletion of record

This is the procedure to which we are passing the parameter called in.
Write this procedure in oracle.

create or replace procedure del(n in number)
is
begin
delete from stud where rno=n;
end;

Write this code in VB. You can write this at onclick event of command button for example.

Set com = New ADODB.Command
com.ActiveConnection = con
com.CommandType = adCmdStoredProc
com.CommandText = “del(” & Text1.Text & “)”
com.Execute

Advertisements