ORA-7445 [strcmp()] When Querying An External Table (Doc ID 862867.1)

Last updated on JULY 24, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

An ORA-7445 [strcmp()] error occurs when querying an external table which has an invalid conditional statement on a column, for example where a NULLIF clause on a column references an invalid column name as in the below example:

CREATE TABLE test_xtrn
  (part VARCHAR2(6),
   node VARCHAR2(65))
  ORGANIZATION EXTERNAL (
    DEFAULT DIRECTORY MISC_DIR
    ACCESS PARAMETERS(RECORDS DELIMITED BY NEWLINE
    LOGFILE 'TEST_XTRN.log'
    BADFILE 'TEST_XTRN.bad'
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LRTRIM
    MISSING FIELD VALUES ARE NULL
      (PART CHAR (6) NULLIF PART1 = BLANKS,
      
NODE CHAR (65)))
    LOCATION (
    MISC_DIR:'TEST_XTRN.csv'))



The trace file will show a call stack similar to the following:


strcmp kudmclf kudmiparms kudmxo kpxsOpen qxxqOpen ...

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