WFLOAD gives Oracle Error: ORA-01480: trailing null missing from STR bind value (Doc ID 1105383.1)

Last updated on JANUARY 14, 2014

Applies to:

Oracle Workflow Cartridge - Version 12.0.6 to 12.2.2 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms



WFLOAD utility fails to download certain workflow definitions:

WFLOAD apps/<passwd> 0 Y DOWNLOAD teste.wft POAPPRV (log_successfully.log)
WFLOAD apps/<passwd> 0 Y DOWNLOAD PAWFPPWP.wft PAWFPPWP (log_error.log)



The error returned is:

- 1300: Could not load.
- 1114: Could not load from database.
- 1115: Could not load all definitions referenced by 'PAWFPPWP' item type.
- 1115: Could not load contents of 'PAWFPPWP' item type.
- 1101: Could not load item types from database. FILTER=PAWFPPWP
- 210: Oracle Error: ORA-01480: trailing null missing from STR bind value. SQL text: SELECT protect_level, custom_level, name, display_name, description, wf_selector, read_role, write_role, execute_role, persistence_type, to_char(persistence_days) FROM wf_item_types_vl WHERE name like :itemtype ORDER BY name

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