Re: PL/SQL proc and '&'

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 09 May 1998 03:34:53 GMT
Message-ID: <6j0isr$192@bgtnsc01.worldnet.att.net>

Execute the SQL*Plus command SET DEFINE OFF. For example:

SQL>SET DEFINE OFF
SQL>CREATE OR REPLACE your_procedure AS .....the rest of your procedure goes here

Jonathan

On Fri, 8 May 1998 10:52:19 -0400, "Haresh Assumal" <assumal_at_sprynet.com> wrote:

>I am having trouble in creating a PL/SQL procedure that has an '&'. When I
>run the script to create a proc using SQL Plus I get prompted for inputs
>whenever there is an '&' character.
><snip>
> How do I get
>this to work?
>Thanks,
Received on Fri May 08 1998 - 22:34:53 CDT