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

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.
1 - 2
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
319 views