Do you know the ORA- nonerrors?

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
ORA-28002: the password will expire within 10 days


My password will expire in 10 days. And this screw up my day 🙁

By Laurent Schneider

Oracle Certified Master


  1. Sound more like a functional bug to use an ERROR facility for warning purpose.

Leave a comment

Your email address will not be published.