> You may be able to work around this by defining 
> PERL_ENV_TABLES to LNM$FILE_DEV, and then defining 
> LNM$FILE_DEV to the list of tables that you want.
> 

Your suggestion does have merit, but the original reason that I
started looking into PERL_ENV_TABLES is because of a need to
ensure that perl doesn't use LNM$FILE_DEV...

Because Oracle 9.2 inserts its own table at the beginning
of LNM$FILE_DEV like this:

  "LNM$FILE_DEV" = "SERVER_810111112"
        = "LNM$PROCESS"
        = "LNM$JOB"
        = "LNM$GROUP"
        = "LNM$SYSTEM"
        = "DECW$LOGICAL_NAMES"

and when a perl script then sets an environment variable, 
e.i. a logical name, then it ends up in the first table
on the list that you have write access to - which in
this case can be the oracle table - with possible bad 
prospects like setting a NLS_LANG value that thereafter
affects the whole system adversely.

> On Thursday, October 21, 2004, at 07:55AM, 
> <[EMAIL PROTECTED]> wrote:
> 

Regards
Jakob Snoer
Nordic Processor
Data Warehouse Handel Drift / 8612
Tlf 436736 
[EMAIL PROTECTED]


Reply via email to