Structure Import With WebADI Doesn'T Work: EGOIJAVA goes in error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" (Doc ID 1392889.1)

Last updated on MAY 15, 2016

Applies to:

Oracle Product Hub - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 09-SEP-2014***

Symptoms

On : 12.1.2 version, Catalog items

EGOIJAVA module: EGO Spreadsheet Java Concurrent Program.
Structure import with WebADI doesn't work if the item number is > 25 chars, then the import of the structure with WebADI fails:

ERROR
-----------------------
[...]
[09/26/2011 11:28:51:354] CommonJCP => returning EGO_BULKLOAD_ENTITIES.BulkLoadEntities with retcode => E
[09/26/2011 11:28:51:354] CommonJCP => returning EGO_BULKLOAD_ENTITIES.BulkLoadEntities with errbuf => Error : -6502---ORA-06502: PL/SQL: numeric or value error: character string buffer too small
[09/26/2011 11:28:51:354] CommonJCP => Setting completion status as Error as one of the called programs returned error
[...]


STEPS
-----------------------

  1. The issue can be reproduced at will with the following steps:
  2. Created the structure type, structure name and import format
  3. Development Manager > Import from Excel (Batch Import: Import Items)
  4. Set Structures for Object
  5. Set Structure Type, Structure Name and Import Format and click Import
  6. After filled the rows of generated excel, upload the file and an error is raised

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms