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)
delete from stud where rno=n;
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 & “)”