Oracle Reports | How to Call Reports from Oracle forms | Bangla R-29

Опубликовано: 05 Март 2026
на канале: OracleDB Solutions

3,008

Oracle Reports | How to Call Reports from Oracle forms | Bangla R-29
To See More Reports Tutorial Click here    • Introduction To Database & Out Line The Se...
To See More Forms Tutorial Click here    • Oracle Forms: How to Install Oracle Databa...

Dear viewer, In this tutorial you will know how to reports call to oracle forms.

PROCEDURE loan_product IS
repid REPORT_OBJECT;
v_rep VARCHAR2(1000);
rep_status VARCHAR2(20);
PL_ID PARAMLIST;
pr_nm varchar2(20):='PNM';
v_rptserver varchar2(10):='nahid'; -----1
--rwserver server=nahid EXCECUTE IT ON RUN
v_host varchar2(20):='localhost'; ----2

BEGIN
PL_ID := GET_PARAMETER_LIST(pr_nm);
IF ID_NULL(PL_ID) = FALSE THEN
DESTROY_PARAMETER_LIST(PL_ID);
PL_ID := CREATE_PARAMETER_LIST(pr_nm);
IF ID_NULL(PL_ID) THEN
MESSAGE('ERROR CREATING PARAMETER LIST '||pr_nm);
RAISE FORM_TRIGGER_FAILURE;
END IF;
ELSE
PL_ID := CREATE_PARAMETER_LIST(pr_nm);
END IF;
--add parameter with separate statement for each parameter
--ADD_PARAMETER(PL_ID, 'P_BDT',TEXT_PARAMETER,:BAZAREXP.BAZARDT); ----3
-- ADD_PARAMETER(PL_ID, 'PSAL',TEXT_PARAMETER,:SALARY);
repid := find_report_object('LOAN_PRO'); ----4

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);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF'); --pdf/html
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_rptserver);
v_rep := RUN_REPORT_OBJECT(repid,PL_ID);
rep_status := REPORT_OBJECT_STATUS(v_rep);
IF rep_status = 'FINISHED' THEN
/*Display report in the browser */
WEB.SHOW_DOCUMENT('http://'||v_host||':8889/reports/rwservlet/getjobid' ||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_rptserver,'_blank');
ELSE
message('Error when running report');
END IF;
END;

To Get more Tutorial Subscribe The Channel
click here    / @oracledbsolutions2678

To Get All Post Like The Facebook Page
Click here   / oracledbsolutions

Follow us:
Facebook:   / oracledbsolutions
Youtube link:    / @oracledbsolutions2678
Facebook Group:   / 465557066961548

Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780