Answer Posted / raj

The APP_DATE routines are located in the APPCORE library
and can be called from forms and other libraries, except
for libraries that are attached to APPCORE, such as the
CUSTOM library.
For code in the CUSTOM library and other libraries attached
to APPCORE, use the APP_DATE2 package in the special
APPCORE2 library. The APP_DATE2 package is equivalent to
APP_DATE, with the same routines and routine arguments.

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2227