If you are facing an issue in not seeing the procedure in a package while configuring DB invoke, make sure that the procedure has atleast one parameter.
If a procedure is created without any parameter DB adatper in OIC integration won't show that procedure at all in the package you browsed. Create the procedure with at least one parameter and reconfigure the DB adapter invoke action.
