DB Package.Procedure Returning Varray
663012Oct 23 2008 — edited Oct 24 2008I 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]