Re: Ampersand problem in SQL*plus

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Wed, 22 Mar 2000 14:39:20 +1100
Message-ID: <8b9fnh$6jj$1@perki.connect.com.au>

You cold set the can off by issueing

set scan off

Tom

Zaid <zaid_at_mail.utexas.edu> wrote in message news:8b91p3$4ep$1_at_geraldo.cc.utexas.edu...
> I'm having a problem using an ampersand ("&") in a named procedure. SQL
> Plus keeps asking me for a value before compiling the procedure. I tried
> enclosing it with quotes, double quotes, and so on... but nothing seems to
> work.
>
> The "&" is part of a URL address which I'm passing as a value.
>
> Anyone know how to solve this problem? Thanks in advance. -Zaid
>
>
Received on Tue Mar 21 2000 - 21:39:20 CST