Re: UTL_FILE and Ampersand (&)

Thanks Anurag. I really need to display the "&" in the filename. What I am doing is generating the files using the ID of the customer and then through a lookup file (CUST ID --> CUSTNM) displaying the "&" on the web where the reports are to be published.

Thanks

"Anurag Varma" <avarmadba.skipthis_at_yahoo.com> wrote in message news:<YXkGa.610$Bw2.13_at_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 Wed Jun 18 2003 - 20:18:56 CDT