Re: Help - compiling PL/SQL packages for webserver and the '&' symbol!!

Well depending on what you are trying to do, the answer may be different. In the event that you are trying to build a get statement so as to create a link to a url and pass parameters within in the link as opposed to a submit form (sometimes you have no choice but to make a hyperlink), then what we do is concatnate a CHR(38) on to our string.

'www.website.com/page1.htm?application_id=12&name=bobby'

would be

'www.website.com/page1.htm?application_id=12'||CHR(38)||'name=bobby'

You can't double ampersand anything either.. kinda of a crummy deal I think. Its okay for reports but not for the web.

On 4 Jul 1999 21:39:43 GMT, chris.hughes_at_gsc.gte.com (Chris) wrote:

>Hello:
>
>I was wondering if someone could tell me if there is an escape character or
>sequence that is necessary to use the ampersand (&) symbol in web
>page hyperlinks that you are generating via PL/SQL packages. When I insert the
>ampersand symbol in my PL/SQL code, at compile time I am prompted for a
>substitution value. I understand why this is happening, I just can't figure
>out how to get around it.
>
>Any help would be greatly appreciated.
>
>Thanks,
>
>-Chris
Received on Sun Jul 11 1999 - 08:48:42 CEST