how to call oracle report from menu oracle 10g developer?

Question

Now I am using Oracle 10g developer But now I am facing some problem. I use this code for report running

run_Product(REPORTS,'D:\Reports\n_sal_sheet_worker.rep', SYNCHRONOUS, RUNTIME,FILESYSTEM,'', NULL);

but report not run. So pls help me. I don't know how to call oracle report from menu oracle 10g developer.

Answer 1

Using the run_product built in is not supported in Oracle Forms 10G onwards.

The following is taken from the Oracle White Paper "Integrating Oracle Reports in Oracle Forms Services applications" which currently can be found here.

Using RUN_PRODUCT to generate Reports output is not supported in Oracle Forms 10G. Form module containing integrated calls to Reports using RUN_PRODUCT Built-in won’t compile.

You should change your code to use the run_report_object built in.

This same document quoted above has an excellent example of how to use run_report_object