Home > sql, sqlplus > Do you know the ORA- nonerrors?

Do you know the ORA- nonerrors?

August 17th, 2010 Leave a comment Go to 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

X

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

Tags:
  1. August 17th, 2010 at 20:47 | #1

    i comletely share your feelings about the expired passwords :)

  2. bernard polarski
    August 20th, 2010 at 08:17 | #2

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

  3. August 20th, 2010 at 09:57 | #3

    Actually there is even the ORA-00000 error that means success

    http://download.oracle.com/docs/cd/E11882_01/server.112/e10880/e0.htm
    ORA-00000: normal, successful completion
    Cause: Normal exit.
    Action: None

  1. No trackbacks yet.
*