How to view the package or table structure reports ora-01460 in PL/SQL developer today someone reported that a database cannot view the package or table structure in PL/SQL developer.
The character set of the server and client is inconsistent.
Check that the character set of the database is zhs32gb18030.
Select * from V $ nls_parameters t where T. Parameter like '% characterset % ';
Parameter Value
Nls_characterset zhs132gb18030
Nls_nchar_characterset al16utf16
Set the client's nls_lang = simplified chinese_china.zhs132gb18030
In this way, the error persists.
In my memory, zhs32gb18030 should contain 4 bytes each.
Check the help --> support info of PL/SQL developer and drag it to the final character sets section. The character size is 3 byte (s)
Start PL/SQL developer on the command line and force PL/SQL Dev to use 4 Bytes/character: plsqldev.exe BPC = 4 Note: BPC (bytes per character ).
Finally, the problem is solved.
Conclusion:
When the database's font set is zhs32gb18030, using PL/SQL developer to view the package or table structure reports a ora-01460
This should be a bug in PL/SQL developer. Solution: add the parameter BPC = 4 when starting PL/SQL developer. For example, plsqldev.exe BPC = 4