Java Development Tools

i got an error "ORA-00932: inconsistent datatypes: expected - got CHAR"

I had used the steve muenchs blog
http://radio.weblogs.com/0118231/stories/2004/09/23/notYetDocumentedAdfSampleApplications.html#1


in that blog have no jspx pages.....he has been created only one ClientTest.java.

i had done emp.jspx page it contains CommandButton and CoreTable.

i got SQL error during statement preparation. Statement: SELECT Emp.EMPNO, Emp.ENAME, Emp.JOB, Emp.MGR, Emp.HIREDATE, Emp.SAL, Emp.COMM, Emp.DEPTNO, Emp.ROWID FROM EMP Emp WHERE (EMPNO in (SELECT * FROM TABLE(CAST(:no AS TABLE_OF_NO))))
Oct 29, 2008 1:53:09 PM oracle.adf.controller.faces.lifecycle.FacesPageLifecycle addMessage
WARNING: ORA-00932: inconsistent datatypes: expected - got CHAR

while running the page.



Emp BackingBean code at commandbutton:

DCBindingContainer dcBind = (DCBindingContainer)bindings;
DCIteratorBinding iterBind= (DCIteratorBinding)dcBind.findIteratorBinding("EmpViewIterator");
EmpView evpao=(EmpView)iterBind.getViewObject();
evpao.setNamesToFind(new String[]{"1","2"});
evpao.executeQuery();




rply me.




Thnaks
Rama.

Edited by: user634195 on Oct 29, 2008 7:19 AM

Edited by: user634195 on Oct 29, 2008 7:20 AM