RE: External Database

RECIBO_DATA or DATA_RECIBO?

From: [email protected] [mailto:[email protected]] On Behalf Of Marvin Rios
Sent: Friday, February 17, 2012 4:30 PM
To: [email protected]
Subject: Re: [toad] External Database


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

From: Marvin Rios <[email protected]<mailto:[email protected]>>
To: Toad Oracle <[email protected]<mailto:[email protected]>>
Sent: Friday, February 17, 2012 5:26 PM
Subject: [toad] 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