Java Development Tools

Hi,

I have a View Object with a query that has a where clause that has uses "in" ( e.g. select projTitle from PROJECT where projId in :projIds)

'projIds' is a bind variable of Array type.

I am trying to pass into this bind variable what it is expecting (an array of projIds that the sql statement can use), and I have not been successful. I am calling a method in the backing bean from the Named Data child tag of the action tag in the bindings section of the pageDef file.

Can you give me the proper syntax and Array object that this bind variable will accept, please? Maybe I'm using the wrong NDType? I've found a couple of different options, but none I can get working.

Page Definition file:

        <action IterBinding="ProjPendingApprovalByApproverVO1Iterator" id="loadPendingApproval"

                InstanceName="SystemAMDataControl.RooProjIdArrayt.ApprovalAM1.ProjPendingApprovalByApproverVO1"

                DataControl="SystemAMDataControl" RequiresUpdateModel="true" Action="executeWithParams">

            <NamedData NDName="projId" NDValue="#{dashboard.projIdArray}" NDType="oracle.jbo.domain.Array"/>

        </action>

VO query:

SELECT ProjectEO.PROJ_ID,

       ProjUtnDtlEO.UTN_TYPE,

       ProjectEO.PROJ_SHORT_DESC,

       ProjUtnDtlEO.PROJ_DTL_ID,

       ProjectEO.PROJ_OWNER,

       VEmployeeInfoEO.FIRST_NAME,

       VEmployeeInfoEO.EMPLOYEE_ID,

       VEmployeeInfoEO.FIRSTNAMELASTNAME,

       VEmployeeInfoEO.LAST_NAME,

       VEmployeeInfoEO.LASTNAMEFIRSTNAME,

       ProjApprovalDecisionDtlEO.PROJ_APPROVAL_DECISION_DTL_ID,

       ProjApproverEO.PROJ_APPROVER_ID,

       ProjApproverEO.APPROVER_LEVEL,

       ProjApproverEO.APPROVER_NUMBER,

       ProjApproverEO.APPROVER_ROLE,

       ProjApprovalDecisionDtlEO.COMMENTS,

       ProjApprovalDecisionDtlEO.PROJ_APPROVAL_DECISION_ID,

       ProjApprovalDecisionDtlEO.LASTUPDATEDBY,

       ProjApprovalDecisionDtlEO.APPROVEDDATE,

       ProjectEO.SYS_STATUS,

       ProjApproverEO.LASTUPDATEDBY AS LASTUPDATEDBY1,

       ProjApprovalDecisionDtlEO.PROJ_APPROVAL_TYPE_ID,

       ProjStatusLkpEO.STATUS_DESC,

       ProjStatusLkpEO.PROJ_STATUS_ID,

       ProjectEO.PROJ_CATEGORY_ID,

       CHAIN.APPROVAL_DESC   

FROM    PTS.PROJECT ProjectEO,

        PTS.PROJ_UTN_DTL ProjUtnDtlEO,

        PTS.V_EMPLOYEE_INFO VEmployeeInfoEO,

        PTS.PROJ_APPROVAL_DECISION_DTL ProjApprovalDecisionDtlEO,

        PTS.PROJ_APPROVER ProjApproverEO,

        PTS.PROJ_STATUS_LKP ProjStatusLkpEO,

        PTS.PROJ_APPROVAL_CHAIN_LKP Chain

WHERE ((ProjectEO.PROJ_ID = ProjUtnDtlEO.PROJ_ID(+))

AND (ProjectEO.PROJ_ID = ProjApprovalDecisionDtlEO.PROJ_ID))

AND (ProjectEO.PROJ_ID = ProjApproverEO.PROJ_ID)

AND (ProjectEO.SYS_STATUS = ProjStatusLkpEO.SYS_STATUS)

AND (ProjectEO.PROJ_OWNER = VEmployeeInfoEO.EMPLOYEE_ID)

AND (ProjApprovalDecisionDtlEO.PROJ_APPROVER_ID = ProjApproverEO.PROJ_APPROVER_ID)

and PROJAPPROVEREO.PROJ_APPROVAL_CHAIN_ID = CHAIN.PROJ_APPROVAL_CHAIN_ID

AND (ProjApprovalDecisionDtlEO.PROJ_APPROVAL_DECISION_ID = 0) 

and PROJAPPROVEREO.APPROVER_LEVEL <>2

and PROJAPPROVEREO.PROJ_ID in :projId

Thanks!