Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REP-300 Error while running report using App Server

429122Sep 24 2004 — edited Nov 4 2007
Hi,

I am currently trying to run a report using the Application Server.
This report is being called from a form.

I am able to connect to the report server and all configurations seems to be correct.
But when I execute the report from the form, I am getting error "Unable to run report"

When I look at the error message in the Report Server queue, I find
"REP-300 Table or View does not exist.."
But that table does exist in the database.

What could be be the problem ?
Please help.
---------------------------------------------
The code in the form that calls the report is

report_id := FIND_REPORT_OBJECT( report_name );

vc_user_name:=get_application_property(username);
vc_user_password:=get_application_property(password);
vc_user_connect:=get_application_property(connect_string);
vc_connect:=vc_user_name||'/'||vc_user_password||'@'||vc_user_connect;


SET_REPORT_OBJECT_PROPERTY(report_id ,REPORT_OTHER, 'paramform=yes p_user_connect='||vc_connect ||' p_servername=repsrv'||' p_action=<host>/reports/rwservlet?' );

v_rep := RUN_REPORT_OBJECT(report_id, parmlist_id);
------------------------------------------------------
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2007
Added on Sep 24 2004
19 comments
25,940 views