Re: Curious about code in privutil.sql

See inline

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:4140992f$0$15557$636a15ce_at_news.free.fr...
>
> "Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca.x> a écrit dans le
message de
> news:BD00d.116652$A8.68734_at_edtnps89...
> > I'm looking at the script modplsql\owa\privutil.sql (as supplied in the
9205
> > security#68 release) and it has the following section:
> >
> > /* The broken line below is intentional */
> > NL_CHAR constant char(1) := '
> > ';
> >
> > Anyone understand what the idea is behind this intentional broken line?
> >
> > --
> > Terry Dykstra
> > Canadian Forest Oil Ltd.
> >
> >
>
> Put a new line character in the NL_CHAR constant.
> Same as NL_CHAR := chr(10);
>

The use of CHR(10) makes your code dependent on the DATABASE character set. On ASCII platforms, it will work. But the day your database is moved to an EBCDIC platform, you are in trouble. On EBCDIC, the new line is CHR(25). With the
solution in privutil, you do not have that problem.

Cheers
Luc
> --
> Regards
> Michel Cadot
>
>
Received on Thu Sep 09 2004 - 14:32:00 CDT