DB Package.Procedure Returning Varray

663012

I have a WebService that is returning the database user id from my login jspx page and backing bean. I have a DB Package.procedure receiving this user id as input and then returning a varray as roles and privs so that I can dynamically build a menu component. All bindings are working properly (I set and then retrieved the value). The only thing left is to get the datacontrol to retrieve the information. It seems to me that the data-control and/or sqlJ implementation cannot find the applications connection to use to access the database. How do I make the datacontrol use the application's connection context or may there be a different issue affecting this?

Result of login:

08/10/23 11:26:42 Value of setUserId: 2188
08/10/23 11:26:42 menuAccessBindValue: 2188

Result when trying to call the package/procedure varray return:
08/10/23 11:26:42 Errors from operBinding: [oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NullPointerException, msg=null]

663012

I changed the java wrappers using sqlj to a webservice. This scenario is working and returning the varray within the backing bean. The only real fix I had to make was to the connection.xml file for the correct port setting.

663012

Package.procedure with input as number and output as varray using webservice.