SOS: PL/SQL to return 0 or 1

Hi Gurus,
I have two instances. On one there is a Java tool which calls a stored procedure. This procedure updates changes made in this instance by the tool, to the other instance.

Now, when I update in the second instance, I am required to return a code of 0 for success and 1 for failure.

How would I manage this in a PL/SQL stored proc???

Thanks!!!

just use a boolean.

however, do you want to know if the procedure COMPLETED? or do you want to kow if there are errors?

two separate checks.

- magnus

Thanks Magnus,
Yes I would need to know
If the commit was completed or not...