Forum Stats

  • 3,767,984 Users
  • 2,252,736 Discussions
  • 7,874,399 Comments

Discussions

Oerr: String to number conversion failed in Oerr.

User_2DKLA
User_2DKLA Member Posts: 11 Green Ribbon

Hello,

SQL> show version
Oracle SQLDeveloper Command-Line (SQLcl) version: 21.3.1.0 build: 21.3.1.281.1748 

SQL> oerr -v

19.3

SQL> oerr ora 39826

Oerr: String to number conversion failed in Oerr

There seems to be a range of error codes between 34500 (give or take a few) and 40000 which trigger the above error.

The oerr binary from the full Oracle client returns the error details successfully:

: $ORACLE_HOME/bin/oerr ora 39826

39826, 0000, "Direct path load of view or synonym (%s.%s) could not be resolved."
// *Cause:   A synonym or view could not be translated.
// *Action:  Verify that the view or synonym is valid.

This is different from trying a non-existent error code:

SQL> oerr ora 1067

Oerr: No match found in Oerr.

ORA-01067 does not exist, so the above "No match" answer is correct. In any case, "String to number conversion failed in Oerr" doesn't look right.

Remark: same behaviour in SQL Developer 21.2.1.

Just thought I'd mention it...

Regards,

Answers

  • User_2DKLA
    User_2DKLA Member Posts: 11 Green Ribbon

    Re-tested with the latest version:

    SQL>  show version
    Oracle SQLDeveloper Command-Line (SQLcl) version: 21.3.2.0 build: 21.3.2.287.1503
    
    SQL>  oerr ora 39826
    
    Oerr: String to number conversion failed in Oerr.
    

    Same error.

    Regards,