PL/SQL:"character string buffer too small" error for specific environment

Can't got the problem,that reproduced on my environment.

Result of running PL/SQL procedure on my PC on Eclipse SQL Explorer:

ORA-06502: PL/SQL: numer开发者_如何学JAVAic or value error: character string buffer too small

If this procedure compiled on other PC on Eclipse SQL Explorer also,that all is OK.

note: If you ask,why Eclipse SQl Explorer - its' historical issue,because procedure isn't compiled under Oracle Sql Developer.

What is problem in my environment?

Thank you.

You need to look for a significant difference in the client environments. For instance, do they have different settings for NLS_LANG? This could matter if you're using a multi-byte character or Unicode character set in your database.

There's an optimization level for PL/SQL procedures. Could be one of your environments is compiling in 'normal' mode and the other in 'debug' mode.

Check the settings for that object in ALL_PLSQL_OBJECT_SETTINGS

Does your code use the DBMS_OUTPUT package? Maybe you have a small limit on DBMS_OUTPUT. Try and increase the size to the maximum allowed (32767).