sqlplus login error via perl system call

[David Sherrington - Enterprise Services- Data Management Systems Engineer]

Hello,

I know that this might not be a DBI issue, sorry, but I'm not sure where to look 
next!

My setup is: perl 5.005 on Solaris 2.6 running Oracle 8.1.6.

I am getting the following error when I try to run sqlplus via a perl system 
call. I have checked all the environment variables all look fine, in fact when I 
run the same sqlplus statement from the unix prompt (with the same environment 
settings) it works fine.

Any ideas as to what might be causing this would be gratefully received.

Many thanks
Regards
David




Below is the code and error:

$return_code = (system("sqlplus user/passwd \@mysql ") / 256);



SQL*Plus: Release 3.3.4.0.1 - Production on Wed Feb 14 05:33:42 2001

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

ERROR: ORA-12705: invalid or unknown NLS parameter value specified


Enter user-name:


My NLS_LANG setting is:

NLS_LANG=american_america.UTF8