Forum Stats

  • 3,783,355 Users
  • 2,254,764 Discussions
  • 7,880,372 Comments

Discussions

DB Package.Procedure Returning Varray

663012
663012 Member Posts: 25
edited Oct 24, 2008 10:46AM in JDeveloper and ADF
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]

Answers

This discussion has been closed.