OraFAQ Forum: Reports & Discoverer » can't pass parameter through cgicmd.dat key

Home » Developer & Programmer » Reports & Discoverer » can't pass parameter through cgicmd.dat key

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can't pass parameter through cgicmd.dat key [message #420349]

Fri, 28 August 2009 08:34

imuharram
Messages: 48
Registered: January 2009

Member

I have a form that sends a value to a report to be generated

report is generated through below url

web.show_document('http://localhost:8889/reports/rwservlet?report=d:\rep.jsp&destype=cache&desformat=pdf&userid=username/password@tnsname&p_wo_no='||:global.wo_no);

p_wo_no is a parameter that takes its value from the form from :global.wo_no

I created a key in cgicmd.dat to hide username and password for security as clarified below

key2:  report=d:\rep.jsp  userid=username/password@tnsname destype=cache desformat=pdf

I have a button in a form to call report using below url

web.show_document('http://localhost:8889/reports/rwservlet?cmdkey=key2&p_wo_no='||:global.wo_no);

the problem is that when report is generated an empty page is displayed

[Updated on: Fri, 28 August 2009 15:35]

Report message to a moderator

Previous Topic:	How to call report parameter at runtime?
Next Topic:	Can you use cursors and if so, how?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 04:28:12 CST 2024