how do we confirm commit?
we have a scenario where in the stored procedure reurns 1 if a statement have commited successfuly.That is i would like to set the value of the status out parameter as 1 if a certain insert statement is successfuly commited.how do i go about it.
is there any means where in i can check if the statement have executed successfully or not.
create procedure P1(status out integer) as
insert into x values(1,1,1,1,1,1);
in the above code how do i check if the value have been inserted successfully and accordingly set the value of the status parameter as 1..