Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Ampersand problem in SQL*plus

Re: Ampersand problem in SQL*plus

From: Paul Druker <pdruker_at_metaway.com>
Date: Wed, 22 Mar 2000 00:58:58 GMT
Message-ID: <mVUB4.768$h3.7229@typhoon.southeast.rr.com>


By default, SQL*Plus uses ampersand to create the substitution variable. You can change it to any other character (e.g. asterisk) by typing

set define *

at the SQL prompt.

Hope that helps,
Paul Druker

"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 - 18:58:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US