Oracle Reports (MOSC)

MOSC Banner

Using RUN_REPORT_OBJECT and ENVID - how does Oracle know what the login/password is?

edited Mar 29, 2016 10:34AM in Oracle Reports (MOSC) 1 commentAnswered ✓

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);


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