[Home] [Help]
26: - ";", "/", "?", ":". "@", "&", "=". "+", "$", ",", "[", "]"
27:
28: This package provides two functions that escape and unescape characters
29: in a URL. The escape function should be used to escape a URL before the URL
30: is used fetch a Web page via the UTL_HTTP package. The unescape function
31: should be used to unescape an escaped URL before information is extracted
32: from the URL.
33:
34: For more information, refer to the Request For Comments (RFC) document
90: * If url_charset is NULL, the database
91: * charset is assumed and no character set
92: * conversion will occur. The default value is
93: * the current default body character set of the
94: * UTL_HTTP package, whose default value is
95: * "ISO-8859-1". The character set can be named
96: * in Internet Assigned Numbers Authority (IANA) or
97: * Oracle naming convention.
98: * EXCEPTIONS
142: */
143: FUNCTION escape(url IN VARCHAR2 CHARACTER SET ANY_CS,
144: escape_reserved_chars IN BOOLEAN DEFAULT FALSE,
145: url_charset IN VARCHAR2 DEFAULT
146: utl_http.get_body_charset)
147: RETURN VARCHAR2 CHARACTER SET url%CHARSET;
148:
149: /**
150: * Unescapes the escape character sequences to their original form in an URL,
159: * If url_charset is NULL, the database
160: * charset is assumed and no character set
161: * conversion will occur. The default value is
162: * the current default body character set of the
163: * UTL_HTTP package, whose default value is
164: * "ISO-8859-1". The character set can be named
165: * in Internet Assigned Numbers Authority (IANA) or
166: * Oracle naming convention.
167: *
191: * This function does not validate a URL for the proper URL format.
192: */
193: FUNCTION unescape(url IN VARCHAR2 CHARACTER SET ANY_CS,
194: url_charset IN VARCHAR2 DEFAULT
195: utl_http.get_body_charset)
196: RETURN VARCHAR2 CHARACTER SET url%CHARSET;
197:
198: END;