Re: UTL_FILE and Ampersand (&)

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Fri, 13 Jun 2003 14:11:04 GMT
Message-ID: <YXkGa.610$Bw2.13@nwrddc03.gnilink.net>

Not a good idea to create files like this. You should replace all non-alphabets out of the name before creating the file.

for example .. try:
l_cust := translate(lower(cust_rec.cust_corp_nm),

'a'||translate(lower(cust_rec.cust_corp_nm),'#abcdefghijklmnopqrstuvwxyz','# '),

                 'a') || 'Q.XLS';

instead of
> > > l_cust:=cust_rec.cust_corp_nm||' Q.XLS';
for your file name.

Anurag

"Pawan" <pawanputrahanuman_at_yahoo.com> wrote in message news:84857442.0306121024.5cec31aa_at_posting.google.com...
> Thanks Ana and Anurag. The OS is HP UX 11 and Oracle version is
> 8.1.7.4. The problem is that UTL_FILE writes to multiple files whose
> name is dictated by the l_cust variable. After writing about 15 files
> the code fails as:
> SQL> @t
> DECLARE
> *
> ERROR at line 1:
> ORA-20001: utl_file.other_error
> ORA-06512: at line 307
>

-snip- Received on Fri Jun 13 2003 - 09:11:04 CDT