Re: External Database
Marvin Rios <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
script of creation CREATETABLEMOBILE.RECIBO_DATA(LOTE ) ORGANIZATIONVARCHAR2(50BYTE)EXTERNAL(TYPEORACLE_LOADERDEFAULTDIRECTORYCONSIGNACIONFIELDS ACCESSPARAMETERS(RECORDS DELIMITED BYNEWLINE(LOTE POSITION(1:25)CHAR(50),))LOCATION(CONSIGNACION:'Archivo.txt')REJECT)LIMITUNLIMITED ________________________________ From: Marvin Rios <[email protected]> To: Toad Oracle <[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