Hi all,
I'm using JDeveloper 12.1.2.0.0. I create a HR demo application and a view criteria to search all employees in employee tab. In this view criteria, I create a view criteria item with a LOV (LOV_DepartmentId) to filter employee by department. After that, I also add a bind variable to Query tab (The query is :
SELECT Employees.EMPLOYEE_ID,
Employees.FIRST\_NAME,
Employees.LAST\_NAME,
Employees.EMAIL,
Employees.PHONE\_NUMBER,
Employees.HIRE\_DATE,
Employees.JOB\_ID,
Employees.SALARY,
Employees.COMMISSION\_PCT,
Employees.MANAGER\_ID,
Employees.DEPARTMENT\_ID
FROM EMPLOYEES Employees
where Employees.HIRE_DATE = :pHireDate )
When I run the application, I get an error message: "Application module is not connected to a database".
If I remove the bind variable (pHireDate ) from Query, the error message disappears; Or when I set pHireDate with hide = true in UI Hints, the error message disappears as well.
I'm concern about the conflict between LOV and bind variable in Query.
Can anyone help me? Thank you in advance.
Regards,
Vu