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???
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.
Yes I would need to know
If the commit was completed or not...