Passing Parameters to Oracle Report Builder Runtime

It’s a little tricky passing parameters to the Oracle Report Builder Runtime when they contain single-quotes. Here’s a way that works:


/oracle/product/8.0.6/bin/rwrun60 module=myReport.rdf batch=yes userid=scott/tiger@demodb.world mode=bitmap destype=file desformat=pdf desname=/report/output/myReport.pdf adt_begin=01-Feb-2007 adt_end=01-Feb-2008 as_lastname="O''Brien"

You wrap the value for non-dates with double-quotes. Change all single-quotes to TWO single-quotes.

as_lastname=
[doubleQuote]O[singleQutoe][singleQuote]Brien[doubleQuote]

Advertisements
Published in: on February 7, 2008 at 9:12 pm  Comments (13)