Toad World® Forums

External Database

Hello All

when Select * from DATA_RECIBO;

send to message

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found “)”: expecting one of: “double-quoted-string,
identifier, single-quoted-string”
KUP-01007: at line 5 column 5
ORA-06512: at “SYS.ORACLE_LOADER”, line 19

script of creation

CREATE TABLE MOBILE.RECIBO_DATA

(

LOTE VARCHAR2(50 BYTE)

)

ORGANIZATION EXTERNAL

( TYPE ORACLE_LOADER

DEFAULT DIRECTORY CONSIGNACION

ACCESS PARAMETERS

( RECORDS DELIMITED BY NEWLINE

FIELDS (

LOTE POSITION(1: 25) CHAR( 50),

)

)

LOCATION (CONSIGNACION:‘Archivo.txt’)

)

REJECT LIMIT UNLIMITED

RECIBO_DATA or DATA_RECIBO?

[ Attachment(s) from Marvin Rios included below]

Attach File view steep for creation external table.

when Select * from DATA_RECIBO;

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

Good Morning Marvin;

Question: if you run your “select * from data_recibo” in SQL Plus, do you
get the same error?

Roger S.