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

Frank van Bortel wrote:
> 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...

Frank, Thanks for the update. I do not use the Web Server Generator. I ran a search of the Oracle documentation for 9.2 and got no hits while my 10g search came back with several hits so I naturally thought the functions were new.

• Mark D Powell --