Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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(DatabaseError.java:137)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)

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

Any idea?

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

1 Answer 1

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

 
discard

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