Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to check for special charcters in an email address using plsql code?

Re: How to check for special charcters in an email address using plsql code?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 18 Aug 2006 21:10:45 +0200
Message-ID: <ec532u$20i$1@news1.zwoll1.ov.home.nl>


Mark D Powell schreef:
>
> I learned about something new. The escape_sc and escape_url appear to
> be new 10g functions for manipulating hmtl within pl/sql code. You can
> find information on these features in the PL/SQL Packages and Types
> Reference.
>
> For pre-10 you will have to roll your own code using instr, substr,
> replace, translate, trim, etc....

Mark - these functions have been part of the Web Server Generator (Designer!) as from the beginning. (1997: OWA. package) Lateron these were promoted to defaults in the OWA packages, as shipped with the Oracle Webserver.

Now there are default with the db install, and are in utl_http, iir.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Fri Aug 18 2006 - 14:10:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US