Current Position:Home > ORA-06502 pl/sql in Oracle warehouse builder

ORA-06502 pl/sql in Oracle warehouse builder

Update:11-30Source: network consolidation
Advertisement
Hi,
I have a problem with using Name and Address operator in Oracle Warehouse builder. When I mapped a table which has more than 7735 rows to another table.
I will get the error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small".
How can I solve this problem?
Thanks a lot!

The Best Answer

Advertisement
The problem is happening again.
When it happens, if I quit and I start again Oracle XE, the problem does not happen at first, but happens again after a while (the duration before the error is not always the same). If I increase the number of lines that are printed for the result of a request, I can induce the error; if I decrease the number of lines, the error is not happening.
Here is one of the request (that request returns about 5000 rows) that cause the error, and the complete error message:
ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur: tampon de
chaîne de caractères trop petit
Translation: buffer for the strings is too small.
select code_pers, nom, prenom, titre, sexe,
date_naissance, pays_nationalite.code_pays_iso,
fonction_institution, code_institution,
complement_adresse_institution, complement_tel_institution,
adresse1_perso_debut, adresse2_perso_rue, adresse3_perso_zip_ville,
pays_adresse.code_pays_iso,
tel_perso, email, site_web, fax,
lower(substr(langue_courrier, 1, 2)),
case
when (adresse_courrier_preferee = 'P') then 'p'
when (adresse_courrier_preferee = 'I') then 'i'
else null
end,
contact_rapide, discipline,
case
when (voeux = 'Vrai') then 'o'
when (voeux = 'Faux') then 'n'
else null
end,
nb_plaquettes, nb_affiches, date_modif
from personne2 join pays2 pays_nationalite
on personne2.nationalite = pays_nationalite.NOM_PAYS
join pays2 pays_adresse
on personne2.pays_perso = pays_adresse.NOM_PAYS
  • ORA-06502 pl/sql in Oracle warehouse builder Update:11-30

    Hi, I have a problem with using Name and Address operator in Oracle Warehouse builder. When I mapped a table which has more than 7735 rows to another table. I will get the error "ORA-06502: PL/SQL: numeric or value error: character string buffer too

  • ORA-06502: PL/SQL with Oracle XE (not with sqldeveloper) Update:11-30

    I have this error message with Oracle XE whereas I have no message at all with the same request if I use sqldeveloper. It seems that the error happens when there is too many information returned by the request. If I add a "where" to select less

  • Ora-06502 pl/sql numeric or value error in Report Query in oracle apex Update:10-11

    Hello all, I need your help... ORA-06502: PL/SQL: numeric or value error: character string buffer too small I am using bi publisher to generate PDF reports in oracle apex. We were using APEX 4.0 and migrated to 4.2 just a week ago. Now we have apex 4

  • ORA-06502: PL/SQL: numeric or value error While Exporting in Oracle 10g Update:10-11

    Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options Export done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set server uses AR8ISO8859P6 character se

  • Oracle.DataAccess.Client.OracleException ORA-06502: PL/SQL Update:11-30

    I have the following Simple PL/SQL function: FUNCTION INSERTFBEXP ( p_expid INTEGER, p_run_identifier     VARCHAR2, p_run_complete     INTEGER, p_run_completion_status VARCHAR2, p_complete_errors INTEGER RETURN INTEGER IS newid INTEGER; concheck INTE

  • Oracle Warehouse Builder ORA-12801 Update:11-30

    We are running Oracle Warehouse builder 9.2 and we are receiving error ORA-12801 at least once a week. We can not recreate the problem. Has anybody ever experienced this problem? If so, how was it resolved? ThanksYou will be better off posting this q

  • Installed Oracle Warehouse Builder which broke SQL Developer Update:11-30

    Version 1.5.4 build MAIN-5940 SQL Developer worked fine. I installed Oracle Warehouse Builder and now SQL Developer cannot make a connection when I click on a connetion in the connectons window. When I look at the properties of the connection they lo

  • Report error:ORA-06502: PL/SQL: numeric or value error: character to number Update:10-11

    The oracle application express environment is created by installing the HTTP Server on the windows server and the application express 3.2.1 components on the 11.1.0.7 oracle database on UNIX. The installation is successfully and have not seen any iss

  • Report error: ORA-06502: PL/SQL: numeric or value error: NULL index table k Update:10-11

    Hi everybody, I have two Distinct Databases on two distinct servers. (Oracle Ent. Release 10.2.0.3.0 on AIX 5.3). After I install the latest patch last week, One of the APEX installation has some problems on Home>Application Builder Page. The error m

  • UTL_SMTP , ORA-06502: PL/SQL: numeric or value error Update:11-30

    Hi there, I have a procedure that sends emails using UTL_SMTP. It is showing the "ORA-06502: PL/SQL: numeric or value error" whenever the message spans over the limit of the varchar2 type (32'767). I want to send in one email more than that limi