Oracle Reports (MOSC)

MOSC Banner

SRW.SET_PDF_ACTION is not working

edited Jun 20, 2017 5:04AM in Oracle Reports (MOSC) 3 commentsAnswered

The following snippet of code in format trigger does not work:

vURL := 'http://<host>:9002/reports/rwservlet?'||:p_drill_down||'&report=dtlsoc.rep'||
                      '&paramform=no&destype='||:destype||'&desformat='||:desformat||
                      '&p_appr='||:appr_apprcode||
                      '&p_bfy='||:appryear||
                      '&p_dept='||:appr_dept||
                      '&p_fund='||:appr_fund ||
                      '&p_action=xyz'||
                      '&p_sdate=0601'||substr(to_char(to_number(:appryear-1)),3,4)||
                      '&p_biids_usr='||user||
                      '&p_edate='||to_char(trunc(sysdate)-1,'mmddrr')||
                      '&server='||:p_server||'&p_server='||:p_server||'&mimetype=application/pdf';

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