Need help getting forms to call reports.
Using the example coding that
was used by oracle but for some reason it is not working. Please help
every time I compile the new code I keep getting errors and I am not
sure how to fix it. I am upgrade from form 6i to forms 11g.
Compilation error on procedure THE_REP:
PL/SQL ERROR 49 at line 35, column 74
bad bind variable 'dept.deptno'
IF upper(:request_status)='C'
THEN
repid := find_report_object('report5');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
Compilation error on procedure THE_REP:
PL/SQL ERROR 49 at line 35, column 74
bad bind variable 'dept.deptno'
IF upper(:request_status)='C'
THEN
repid := find_report_object('report5');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
0