Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06502, ORA-06512 and pad string errors
ORA-06502, ORA-06512 and pad string errors [message #19102] Thu, 28 February 2002 06:15 Go to next message
nigel
Messages: 7
Registered: April 2001
Junior Member
I have a function called padstring used to help in the selection of statments from multiple tables. Sometimes i get the following error

51 52 53 ||padString( bfv.short_display, 5)
*
ERROR at line 39:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

I have checked the tables, all of the columns have correct data types and lengths
Re: ORA-06502, ORA-06512 and pad string errors [message #19109 is a reply to message #19102] Thu, 28 February 2002 07:04 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
check the length of the variable and the length of data u r trying to assign
Re: ORA-06502, ORA-06512 and pad string errors [message #20052 is a reply to message #19109] Fri, 26 April 2002 10:22 Go to previous message
EmailMe
Messages: 1
Registered: April 2002
Junior Member
You may check the Maximal Lenth Of the Bloc Elements in Form Builder, if he is equal to the one in the database.
I had the same error and that was the solution.
Previous Topic: Trigger on a Table
Next Topic: SQL update script help
Goto Forum:
  


Current Time: Fri Mar 29 03:43:47 CDT 2024