Home » Developer & Programmer » Data Integration » OWB 9i Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
OWB 9i Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #203844] Thu, 16 November 2006 09:40 Go to next message
rajkhatua
Messages: 3
Registered: October 2006
Location: new delhi
Junior Member
Hi,
I am using OWB 9.2 in my ETL project. I am fetching data from SQL SERVER 2000 and inserting it into Oracle 9i target. I am facing ORA-06502: (PL/SQL: numeric or value error: character string buffer too small) error when i try to execute my mapping. The configuration parameter bulk size is 50. When i increase the bulk size (greater then the total record count) it execute properly.

Can any body help me regarding this problem.

Thanks in advance.

#Raj
Re: OWB 9i Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #203876 is a reply to message #203844] Thu, 16 November 2006 15:31 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It might mean that column in MS SQL Server 2000 is larger than the same column in Oracle database, or you are trying to insert NULL value into a variable which is declared as NOT NULL.

You should change data, its manipulation or declaration in order to avoid constraint violation.
Re: OWB 9i Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #203908 is a reply to message #203876] Thu, 16 November 2006 22:45 Go to previous messageGo to next message
rajkhatua
Messages: 3
Registered: October 2006
Location: new delhi
Junior Member
This is not the problem of voilation of not null constraint and data type length because data successfully inserted into target table if configration parameter 'bulk size' is greater than total no of records.
Re: OWB 9i Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #203929 is a reply to message #203908] Fri, 17 November 2006 00:07 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there, perhaps, any other error? See what Oracle says about the error you received:
Oracle
ORA-06502 PL/SQL: numeric or value error string

Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).

Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.

I'm sorry, but I wouldn't know what else might be wrong and/or what impact to the whole thing has a 'bulk size' parameter.
Previous Topic: Table desriptions in OWB
Next Topic: VLD-2771: System privileges may not allow extraction from source Table
Goto Forum:
  


Current Time: Thu Mar 28 10:33:36 CDT 2024