Re: PL/SQL Web Toolkit - JavaScript Escape Character

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Wed, 5 Nov 2003 19:41:23 -0500
Message-ID: <cOudnRtIgMZ4BTSiRVn-uw@comcast.com>

you must be working in SQL*Plus

'&' is the default 'define' character to indicate SQL*Plus substitution variables

either
a) SET SCAN OFF -- quick fix
b) Use a different tool to compile procedures -- like TOAD (free TOAD is still available at http://www.toadsoft.com/)

you really want to use something other than SQL*Plus if you're doing any serious web toolkit development

-- 
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
(888) 512-2048


"DJ Modulate" <djmodulate_at_yahoo.com> wrote in message
news:25e65132.0311051607.1388337f_at_posting.google.com...


> Hello:

>

> I have a package with a stored procedure that writes HTML and

> JavaScript to a page.  One line of the JavaScript reads:

>

> htp.print('if (bNoError == true && isBlank(form.emp_telephone) ==

> false) {');

>

> The problem is with the ampersands.  When I compile the package, I

> receive no errors, but I am prompted to enter a value for isBlank

> (Oracle thinks I want to define it as a variable on-the-fly).

>

> If I enter "&& isBlank" I can get around the problem, heh.  But I

> figure that there must be a correct way to get around this problem,

> perhaps some sort of escaping?

>

> Thanks in advance.

>

> -Keith

Received on Wed Nov 05 2003 - 18:41:23 CST