| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Escape Text in PL/SQL
A copy of this was sent to robert.bowen_at_mubimedia.com
(if that email address didn't require changing)
On Sat, 12 Jun 1999 15:48:12 GMT, you wrote:
>I know you can do an ESCAPE 'text' in SQL but how can you escape text
>in PL/SQL? For example, when I print my page via htp.p, I want to do
>the following:
>
>htp.p('text<a href="javascript:func(\'' || variable || '\')"> text ');
>
htp.p('text<a href="javascript:func(''' || variable || ''')"> text ');
will do it -- '' = ' in a character string constant.
>As you see, I need the parameter passed to my javascript function to be
>inside quotes. But the "\" I use does not work. Is this possible?
>
>Thanks in advance.
>syg
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/
Current article is "Fine Grained Access Control", added June 8'th
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA--
 |
 |