This content has been marked as final. Show 2 replies
First I would advise you to register and post on the firstname.lastname@example.org alias - you can find the details of how to do this on the OpenESB site..... you'll reach a larger audience this way.
Second, you need a Stored Procedure in Oracle to do this, then use this from the DB BC, here's one I created which does something similar, i.e. returns a value I'm interested in after an "Update" statement....
CREATE OR REPLACE PROCEDURE "NEXTAPPNUMFINDER" (nextAppNum OUT NUMBER)
SET APPLICATION_NUMBER_NEXT = APPLICATION_NUMBER_NEXT + 1
Hope this helps