Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I got an email from a user when he sees the following error output when he's using our web site.

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "WEB_OWNER.SSFP_GET_WE_OBJ", line 300 ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(

This is error from oracle webconnect, Oracle Application Server Containers for J2EE 10g (

Any idea?

share|improve this question
Not without seeing the source code. – Paul Tomblin May 9 '10 at 15:32

The problem is in the error and is common in all programming languages. Your variable is too small for the value you are putting in it. This is a common pl/sql exception. The easy way to keep this from happening is to anchor your pl/sql variables to columns. Do NOT do this

variableName variableType(Variable length)

If you change a column, to make it longer you need to change code to make the variable wider. Do this:

variableName column.table%TYPE

So if you want to base a variable off of the employees table and the customer name field do this

vCustomerName employees.customerName%type;

This has been available in pl/sql for 15-20 years.

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.