My Oracle Support Banner

Data Load Definition Transformation Rules Fail With Error ORA-30001 (Doc ID 2991946.1)

Last updated on DECEMBER 08, 2023

Applies to:

APEX Application Development - Version NA and later
Oracle Application Express (APEX) - Version All and later
Information in this document applies to any platform.


When attempting to configure a Data Load, the following error occurs:
ORA-30001: trim set should have only one character

The issue can be reproduced at will with the following steps:

Configure a data load with trim expression 1 ' ' (single quotes around space):
1.- Go to Application ID  >  Shared Components  >  Data Load Definitions  >  Data Load Definition Details  >  Data Profile.
2.- Click on Edit Data Profile.
3.- Click on Edit (the pencil) beside the column name.
4.- Click on the Transformation Type list and select Trim.
5.- In the Expression1 text box type: ' ' (single quotes around space)
6.- Apply changes.
7.- Run the application and try to upload the file.
8.- The error returned is: ORA-06502: PL/SQL: numeric or value error




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.