Hello Tom,

I have an application, designed in Jdeveloper 11.1.2.4.0. In this application I have a view object with many employee ids based upon its query. I then call upon a function, this function uses these ids and returns a yes/no answer based upon some logic. If yes then I place said employee id into an array, upon completion of the method which calls upon the function and so forth I compose an array of said employee ids. I have declared the array as follows and call upon the view object I need to accept the array as bind variable.

ArrayList    empList = null;

empList = new ArrayList();

while (hasNext())

call function.....

if(yes)
  empList.add(empID)

ViewObjectImpl voImpl = (ViewObjectImpl) appMod.findViewObject(empWithYes);
voImpl.setNamedWhereClausePram("EmpIdsArray", empList.toArray());
voImpl.executeQuery;

In the called upon view object I have a defined a bind variable named = EmpIdsArray with a type of ARRAY. The SQL statement does the following:

Select employeeName
From   employees
Where  employees.employee_id IN (:EmpIdsArray);

I have verified the composed array is being populated as expected. However when I try and execute the application I receive the following error and have been at a loss to solve as every example I have found is slightly off in implementation style or my understanding of them.

Error: oracle.jbo.JboException : Cannot insert/update Array with out context information.

I have tried to define the bind variable in the property manager with ColumnType = EmployeeId and ElemType = BigDecimal with no success.

SQL> create table t ( x int );

Table created.

SQL>
SQL> insert into t values (1);

1 row created.

SQL> insert into t values (2);

1 row created.

SQL> insert into t values (3);

1 row created.

SQL> insert into t values (4);

1 row created.

SQL> insert into t values (5);

1 row created.

SQL>
SQL> create or replace
  2  type my_num_list is table of number;
  3  /

Type created.

SQL>
SQL> set serverout on
SQL> declare
  2    n my_num_list := my_num_list(2,3,4);
  3  begin
  4    for i in (
  5      select *
  6      from   t
  7      where  x in ( select column_value from table(n) )
  8    )
  9    loop
 10      dbms_output.put_line(i.x);
 11    end loop;
 12  end;
 13  /
2
3
4

PL/SQL procedure successfully completed.