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