Oracle Forms (MOSC)

MOSC Banner

Need help getting forms to call reports.

edited Sep 19, 2013 2:26AM in Oracle Forms (MOSC) 5 commentsAnswered
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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center