thanks for the update.
why does oracle do silly things like that and not fix the real problems with
their tools?
"Anurag Varma" <avdbi_at_hotmail.com> wrote in message
news:l2hqb.17491$v26.4088_at_news01.roc.ny...
>
> 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:35:56 CST
