SQL Language (MOSC)

MOSC Banner

18c inline external table (ORA-7445)

edited Aug 8, 2018 5:02AM in SQL Language (MOSC) 1 commentAnswered

Hi,

My first attempt with inline external table just didn't work. Is any body encountered similar issue?

create directory TK_DIR as '/u01/app/oracle/diag/rdbms/prodcdb/PRODCDB/trace';

echo gg > /u01/app/oracle/diag/rdbms/prodcdb/PRODCDB/trace/gg.txt

WITH po AS (

  SELECT *

  FROM EXTERNAL (

        (

          etext char(2000 BYTE)

    )

    type oracle_loader

    default directory TK_DIR

    access parameters

        (

            RECORDS DELIMITED BY NEWLINE

            FIELDS (etext char(2000))

        )

    location ('gg.txt')

    REJECT LIMIT UNLIMITED

  )

)

SELECT *

FROM po;

ERROR at line 1:

ORA-03113: end-of-file on communication channel

Process ID: 11788

Session ID: 155 Serial number: 32599

2018-07-31T10:46:28.588733-04:00

PLAY1(3):Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x3450ED5, kkslMarkLiteralBinds()+261] [flags: 0x0, count: 1]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center