Usage of double quotes

[guru.bh...@gmail.com]

Hi All,
I have an insert statement that is embedded in a PHP code. It
basically inserts a JS string. We have lots of single quotes inside
the string which we replace by double single quotes. It works fine,
but strangely now, the dev team wants to enclose the whole string in
double quotes. Is there a way of enclosing the entire string in double
quotes? I know Oracle doesn't permit using the same.

This is a part of the string -

)+6;pVM=pVF.substring(y,pVF.indexOf(".",y));}}
else if (window.ActiveXObject && window.execScript){
window.execScript('on error resume next\npVM=2\ndo\npVM=pVM+1\

Thanks in advance
Guru

["Álvaro G. Vicario"]

guru.bh...@gmail.com escribi�:

If you use the proper functions to escape or bind arguments, Oracle
should not care about what's inside your string (beyond charset issues,
which is a different story).

Are you sure your problem is not related to HTML/JavaScript? In
JavaScript, if you need to insert a double quote in a double quote
delimited string, you need to escape with backslashes:

var foo = "y,pVF.indexOf(\".\",y));";

--
-- http://alvaro.es - �lvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programaci�n web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

[gym dot scuba dot kennedy at gmail]

<guru.bh...@gmail.com> wrote in message
news:403784fb-d7c8-4a05...@h18g2000yqj.googlegroups.com...

use bind variables and then you won't care how the string is quoted.
(also you won't be subject to sql injection, you application will preform
better and scale better)
Jim