Re: PL/SQL Web Toolkit - JavaScript Escape Character

A minor note:

set scan off is an obsolete command still available in 9i sqlplus. It might not be available in future versions.

set define off should be used from 9i onwards.

Anurag

"mcstock" <mcstockspamplug_at_spamdamenquery.com> wrote in message news:cOudnRtIgMZ4BTSiRVn-uw_at_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 - 19:00:01 CST