not able to print using sqlplus nghuman@RMSPRD
We have a customized form to print some orders. I am able to run this package without any error if I login using
sqlplus
username
password
but it doesn't work with
sqlplus username@RMSPRD
Password
dbrmsproddb:/app/oracle/product/10.2.0/network/admin $ sqlplus nghuman@RMSPRD
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 16 15:29:56 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec run_unix_cmd('/usr/bin/lpstat 2> /tmp/lptst3.txt');
PL/SQL procedure successfully completed.
SQL> !cat /tmp/lptst3.txt
sqlplus
username
password
but it doesn't work with
sqlplus username@RMSPRD
Password
dbrmsproddb:/app/oracle/product/10.2.0/network/admin $ sqlplus nghuman@RMSPRD
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Oct 16 15:29:56 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec run_unix_cmd('/usr/bin/lpstat 2> /tmp/lptst3.txt');
PL/SQL procedure successfully completed.
SQL> !cat /tmp/lptst3.txt
0