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]

Published in: on February 7, 2008 at 9:12 pm Leave a Comment

The URI to TrackBack this entry is: http://dmcmeans.wordpress.com/2008/02/07/passing-parameters-to-oracle-report-builder-runtime/trackback/

RSS feed for comments on this post.

Leave a Comment