My Oracle Support Banner

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

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
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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