URL encoding for links w/ PL/SQL

From: Joseph Ranseth <jranseth_at_worldNO_SPAMcupfishing.com>
Date: Mon, 25 Sep 2000 14:51:36 -0500
Message-ID: <70Oz5.2302$fU3.55994_at_news1.mts.net>


[Quoted] How do I format a string variable to be used as an URL?

I have some string values containing spaces and ampersands, and they don't create the proper links. ie: the following produces a result that does not work.
value = "Big & Burly"
htp.prn("/my_page?in_value='||value);
[Quoted] [Quoted] creates link "/my_page?in_value=Big & Burly", which passes an incoming parameter of "Big " as the & character seperates values in an URL.

I know ASP uses a URLEncode function. What is the equivalent in PL/SQL?

--
Joseph Ranseth - Webmaster
World Cup Fishing
http://www.worldcupfishing.com
Received on Mon Sep 25 2000 - 21:51:36 CEST

Original text of this message