-
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!!!
Hemant
-
boolean
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...
Hemant
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|