# External Database

**URL:** <https://forums.toadworld.com/t/external-database/11038>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 17, 2012, 4:26pm UTC](https://forums.toadworld.com/t/external-database/11038 "2012-02-17T16:26:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2012, 4:26pm UTC](https://forums.toadworld.com/t/external-database/11038/1 "2012-02-17T16:26:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2012, 4:30pm UTC](https://forums.toadworld.com/t/external-database/11038/2 "2012-02-17T16:30:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2012, 4:40pm UTC](https://forums.toadworld.com/t/external-database/11038/3 "2012-02-17T16:40:48Z")

</div>

RECIBO\_DATA or DATA\_RECIBO?

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 18, 2012, 9:05am UTC](https://forums.toadworld.com/t/external-database/11038/4 "2012-02-18T09:05:55Z")

</div>

[Attachment(s) from Marvin Rios included below]

Attach File view steep for creation external table.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 21, 2012, 10:19am UTC](https://forums.toadworld.com/t/external-database/11038/5 "2012-02-21T10:19:42Z")

</div>

> > 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.
