Which version of OSB are you using? What is the result of testing the business service that is calling PL/SQL package? Please paste the entire error stack.
Kindly check DB is connecting while calling the service and listener is configured properly as mentioned by Prasanna G provide the logs and version of OSB for better analysis
Thank you Prasanna & vananthafor your help.
We were able to resolve it by applying the following patch.