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

Question

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: numeric 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.

is the input data the same in both cases? This error normally means your code is attempting to assign a string to a variable that is too small for it.. — StevieG
– StevieG, Commented Jun 1, 2011 at 10:58
@StevieG absolutely identical procedures and their input params for run. The only difference,that if proc. compiled from other PC,that there is no such error.Perhaps,some SQL Explorer settings? — sergionni
– sergionni, Commented Jun 1, 2011 at 11:03
Are you getting the error when compiling, or running the proc? Would be useful if you could post the code.. — StevieG
– StevieG, Commented Jun 1, 2011 at 11:05
getting error when running only,compilation is OK,procedure size is more than 1K lines — sergionni
– sergionni, Commented Jun 1, 2011 at 11:07
I'm stumped, then.. The procedure is running on the database, so it shouldn't matter what your SQL explorer settings are. Is the database hosted locally on your machines? — StevieG
– StevieG, Commented Jun 1, 2011 at 11:18

APC · Accepted Answer · 2011-06-05 20:01:36Z

2

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.

edited Jun 5, 2011 at 20:01

answered Jun 5, 2011 at 9:07

APC

147k20 gold badges180 silver badges289 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sergionni Over a year ago

thank you, for now I'm out of this task,anyway keep it in mind

Gary Myers · Accepted Answer · 2011-06-06 00:06:06Z

1

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

answered Jun 6, 2011 at 0:06

Gary Myers

35.5k4 gold badges52 silver badges77 bronze badges

Comments

Klas Lindbäck · Accepted Answer · 2011-06-07 10:47:39Z

1

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).

edited Jun 7, 2011 at 10:47

answered Jun 1, 2011 at 13:22

Klas Lindbäck

33.4k5 gold badges61 silver badges85 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related