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 (12)  

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

RSS feed for comments on this post.

12 CommentsLeave a comment

  1. Hi, can you tell me please, how could I replace
    userid=scott/tiger@demodb.world with te current user conected to the database whitout prompt the login box?
    Thank you very much…

  2. Thanks for the marvelous posting! I seriously enjoyed reading it, you happen to be a great author.
    I will make certain to bookmark your blog and
    will often come back from now on. I want to encourage you to continue your great writing, have
    a nice day!

  3. Thanks for the marvelous posting! I seriously enjoyed
    reading it, you happen to be a great author. I will make certain to bookmark your
    blog and will often come back from now on. I want to encourage you
    to continue your great writing, have a nice day!

  4. If, at the end of this time period, the score is tied,
    there are two options the officials can take.
    Just last year Apple sold more than one hundred million i –
    Phone and i – Pad apps. The nature of Reddit’s platform makes it possible — through great and creative effort, it appears — to give users a gift of the unexpected, rather than deriving humor from humiliation.

  5. a Bruce Lee workout includes stretching, bending, running, dipping,
    kicking, jumping, traditional muscle building exercises, weight lifting,
    rope skipping, medicine ball handling, etc.

    Vitamin B3 or also called as Niacin is important in weight loss
    because it is responsible for the regulation of thyroid hormones and
    also in sugar levels in the body. Many people don’t have the time to weight themselves every day, but checking the scale on a regular basis can definitely help when you’re working to lose weight
    and keep it off.

  6. Dominion: Intrigue is a standalone expansion for the award-winning Dominion card game
    that shook the gaming world in 2008. If you are unable to sign in to Game Center or are having problems staying connected:
    . Making your game play is the next phase you’ll be focusing on.

  7. Too many folks have already thrown away plenty
    of good money on nothing but useless salt tablets being shipped from South America.
    Authorities inside the area will need to have an intensive understanding
    of laboratory and labeling techniques, infection
    security precautions, appropriate blood attract approaches to the elderly and for infants and even
    more. Many people don’t have the time to weight themselves every day, but checking the scale on a regular basis can definitely help when you’re working to lose weight and keep it
    off.

  8. Greate pieces. Keep writing such kind of info on your blog.
    Im really impressed by it.
    Hey there, You’ve performed an incredible job. I’ll certainly digg it and in my view suggest to my friends.
    I am sure they’ll be benefited from this web site. Then play the Songs back and sing along with the music while the words of the tune get displayed.

  9. a Bruce Lee workout includes stretching, bending, running, dipping, kicking, jumping,
    traditional muscle building exercises, weight lifting, rope
    skipping, medicine ball handling, etc. For many working to lose weight, one failure is enough to get them off the
    path to success. That way, the actual process will end up being
    much less frustrating and, for the majority
    of people, enjoyable.

  10. If you find it a bit maddening to follow the daily fluctuations of
    the scale even though you are eating properly,
    pick three days of the week on which you will always weigh yourself
    (for example, Monday, Wednesday, and Friday).

    Cucumber contains sterols which can help to lower cholesterol and prevent carbohydrates from converting
    to body fat. Expect to lose all that extra flabbiness as you melt off all your unwanted fat.

  11. I’ve learn some good stuff here. Definitely price bookmarking for revisiting. I wonder how a lot effort you put to create such a fantastic informative web site.

  12. I like it when folks get together and share ideas.
    Great blog, stick with it!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: