Do you know the ORA- nonerrors?
August 17th, 2010
3 comments
In one of my script, I am checking at the end for any ORA- error. And if I have any ORA- error, I quit with an error.
So far so good.
Also when I run a report from the shell, I do set the sqlplus settings I like and I expect the script to receive the output with no ORA- error at the beginning.
But watch this !
$ echo "set feed off hea off newp none
conn scott/tiger
select * from dual;"|sqlplus /nolog
ERROR:
ORA-28002: the password will expire within 10 days
XMy password will expire in 10 days. And this screw up my day 