Passing special characters in Oracle BI EE

I saw a question on Oracle IT Toolbox the other day. A subject which I mentioned this earlier.

Passing special characters in Oracle BI EE is something you should avoid as much as possible. If you have to cope with these special characters, eg. in a GO-url, please refer to a site which handles HTML URL Encoding; http://www.w3schools.com/TAGS/ref_urlencode.asp

If  you have a string with spaces, you could use the ‘REPLACE’-function to substitute the space with; ‘%20’. If necessary you could nest the ‘REPLACE’-function to also substitute ‘&’ with ‘%26’.

Something like; REPLACE(REPLACE(string, ‘ ‘, ‘%20’), ‘&’, ‘%26’)

Good Luck

One thought on “Passing special characters in Oracle BI EE

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.