Load External View Fails with ORA-01098 and ORA-01458 (Doc ID 361047.1)

Last updated on JANUARY 20, 2011

Applies to:

Oracle Clinical - Version: 4.0.3 to 4.5.1 - Release: 4 to 4.5
Information in this document applies to any platform.
Checked for relevance on 2-Jan-2011

Symptoms

Load External view process ends with failure. The following messages are reported in 
the process output file:

SQL data loaded from file
0 Tokens found
SAS data loaded from file
Validating view name
View name validated
Creating new view
Data extract view record created

ORA-01098: program Interface error during Long Insert
ORA-01458: invalid length inside variable character string


--
Navigation:
Conduct -> Data Extract -> Load external view ->

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