0012906: If you fill a field with the maximum length permited and one of the character is special it fails when saving

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0012906

Openbravo ERP

02. Master data management

public

2010-04-07 18:15

2010-04-19 07:31

Reporter

adrianromero

Assigned To

adrianromero

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40MP12

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0012906: If you fill a field with the maximum length permited and one of the character is special it fails when saving

Description

If you fill a field with the maximum length permited and one of the character is special it fails when saving

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "TAD_240_FULL.C_BPARTNER_LOCATION_TRG", line 70 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-04088: error during execution of trigger 'TAD_240_FULL.C_BPARTNER_LOCATION_TRG'

Steps To Reproduce

1. Master Data Management || Business Partner || Business Partner >> Location/Address: create new record
2. Press Location selector and set 1st line= áaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa (60length with special character)
SAVE
3. Try to deactivate the record and you will get the error

If you create a new record with 1st line= aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa (60length with NO special character) you can deactivate record without problems

Proposed Solution

Additional Information