ORA-00162: external dbid length is greater than maximum...

Problem

You get this error when building your application using the Application Wizard:

Application Wizard

The following errors occurred:

Failed to process DATABASE.TABLE.  Failed to access the database DATABASE on the server SERVER.  ORA-00162: external dbid length XX is greater than maximum (YY)

 

Oracle does not allow the "Local Net Service Name Configuration" to be greater than 16 characters.

Solution

Specify a database server name that is 16 characters or shorter.

See Also

Part VII:  Troubleshooting Applications

Application Generation and Compilation Error Messages