Re: Import data from ascii file into oracledb. Best method to gain access to db.

"Morgana" <morganalefaye_at_gmx.de> wrote in message news:feb649e0.0110300131.44b559d1_at_posting.google.com...
> Hello!
>
> We are not used to work with an oracle db-server and now
> we have to read an ascii-file with different block-lenght and varying
> information in it and put this information into different tables in
> the oracle db. Which is the easiest way to do it ? Is it better to use
> OCI oder OO4O or what else can or should we use ?
> Please give an easy example, too .
>
> Thanx

Oracle has a product called sql*loader for this purpose which comes with any version of Oracle server software. It would be duplicate work to write your own software.
Sql*loader is documented and annotated with examples, in the Oracle Server Utilities Manual. The examples are by default also installed on the server, and called ulcase*.ctl.
As you don't specify a version, and the location of the scripts is version specific, you have to search yourself for them.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address