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;

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