Re: UTL_FILE and Ampersand (&)

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 12 Jun 2003 01:30:41 GMT
Message-ID: <5JQFa.1073$Zk6.38@news02.roc.ny.frontiernet.net>

I have no idea what exactly are you referring to. What do you mean by in pl/sql it will fail? Can you post the code which fails?

Anurag

"Pawan" <pawanputrahanuman_at_yahoo.com> wrote in message news:84857442.0306111301.76b3f2c2_at_posting.google.com...
> Hi all,
> I am trying to write multiple files to the utl_file_dir which is set
> to /tmp on my server. I am trying to generate multiple files - one
> file per customer and there are 1000 customers. One of the customers
> is A&P Stores. My code fails because if the ampersand. Is there a
> solution to this? In SQL*Plus I could say "set define off" but in
> PL/QSL ....Here is my code

---snip-- Received on Wed Jun 11 2003 - 20:30:41 CDT