OraFAQ Forum: Reports & Discoverer » Passing parameters with cgicmd.dat

Home » Developer & Programmer » Reports & Discoverer » Passing parameters with cgicmd.dat (OAS 10GR2)

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

Passing parameters with cgicmd.dat [message #577392]

Thu, 14 February 2013 12:47

heiava_teata
Messages: 2
Registered: February 2013
Location: French polynesia

Junior Member

Hello,
i try this url:
http:/server_name:7777/reports/rwservlet?url_config&my_parameter

with this key in my cgicmd.dat :

url_config: server=ed_url2 report=%1 userid=user/passxd@base destype=file desformat=pdf

and i have this error:

Unable to open file 'my_parameter='.

The rwservlet converts the value of my parameter to 'my_parameter='.
It adds a '=' systematically at the end of my parameter.

Please need help

Report message to a moderator

Re: Passing parameters with cgicmd.dat [message #577398 is a reply to message #577392]

Thu, 14 February 2013 13:32

Littlefoot
Messages: 17255
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here's how I do that (an Application Express example, but never mind).

CGICMD.DAT entry looks like this:

odr_objekt_po_nedost: server=rep_ias report=odr_objekt_po_nedost.rdf  userid=my_user/my_passwd@ora10 destype=cache desformat=PDF %1

As you can see, I put my parameters to the end.

URL is created as follows:

  :P36_URL := 
     pkg.f_report_server ||
    'odr_objekt_po_nedost'       ||
    '&par_obj='                  || :P36_OBJ;

- pkg.f_report_server is a function that returns server name (http://rep-ias/reportss/rwservlet?)
- odr_objekt_po_nedost is a CGICMD.DAT entry name
- par_obj is a report parameter. I put value of the P36_OBJ page item into it.

Finally, it evaluates to

http://rep-ias/reports/rwservlet?odr_objekt_po_nedost&par_obj=TS

You used %1 parameter as a report name; I don't know whether you can do that or not. What happens if you hard code its name?

Report message to a moderator

Re: Passing parameters with cgicmd.dat [message #577404 is a reply to message #577398]

Thu, 14 February 2013 14:12

heiava_teata
Messages: 2
Registered: February 2013
Location: French polynesia

Junior Member

Thank you for your reply,
however, the problem arises for any type of parameters (report_name, file_name etc ...).
each time it inserts a '=' at the end of the value of my parameter.
My application runs over a hundred report.
I would use a url syntax applicable to all these editions. This is the reason why I want to avoid hard-coding the name of my reports.
Hence my desire to go through the file cgicmd.dat.

PS: sorry for my english, but i speak french and i use google translator

Report message to a moderator

Previous Topic:	rep 1800 formatter error
Next Topic:	Report Builder has stopped working.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 10:04:52 CDT 2013

Total time taken to generate the page: 0.13390 seconds