Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB Package.Procedure Returning Varray

663012Oct 23 2008 — edited Oct 24 2008
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]
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2008
Added on Oct 23 2008
#application-development-in-java, #connection, #db, #jdeveloper-and-adf, #procedure, #webservice
2 comments
320 views