hi,
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.

Example :

create procedure P1(status out integer) as

begin

insert into x values(1,1,1,1,1,1);
commit;

end;

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..

Any help will be appreciated...

Regards
Kaushik