18c inline external table (ORA-7445)
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]