Using RUN_REPORT_OBJECT and ENVID - how does Oracle know what the login/password is?
Hello,
I have a piece of code in my form that uses RUN_REPORT_OBJECT.
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,FILE); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESNAME,r_get_url.replist||'\'||l_filename); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_FILENAME,r_get_url.reppath||p_report_to_run||'.rdf'); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,r_get_url.repserv); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'ENVID="'||r_get_url.machine||'" P_SEQ_REP_NO='||TO_CHAR(p_seq_rep_no)||' blankpages=no'); -- Param list for report RRLOGP01.LOG_DEBUG(p_program_name => 'GBRRINV010', p_text => 'Before RUN_REPORT_OBJECT', p_procedure_name => 'GEN_REPORT'); RRLOGP01.LOG_DEBUG(p_program_name => 'GBRRINV010', p_text => 'REPORT_DESNAME='||r_get_url.replist||'\'||l_filename, p_procedure_name => 'GEN_REPORT'); RRLOGP01.LOG_DEBUG(p_program_name => 'GBRRINV010', p_text => 'REPORT_FILENAME='||r_get_url.reppath||p_report_to_run||'.rdf', p_procedure_name => 'GEN_REPORT'); RRLOGP01.LOG_DEBUG(p_program_name => 'GBRRINV010', p_text => 'REPORT_SERVER='||r_get_url.repserv, p_procedure_name => 'GEN_REPORT'); RRLOGP01.LOG_DEBUG(p_program_name => 'GBRRINV010', p_text => 'REPORT_OTHER=ENVID="'||r_get_url.machine||'" P_SEQ_REP_NO='||TO_CHAR(p_seq_rep_no)||' blankpages=no', p_procedure_name => 'GEN_REPORT'); v_rep := RUN_REPORT_OBJECT(repid);
0