Re: Escape sequences in SQL*Loader

Morten Myrvold wrote:
>
> Billy Verreynne wrote in message <662uu5$bri$1_at_hermes.is.co.za>...
> >The only way (other than replacing CR's before loading) is to make use of
> >the FIX option in SQL*Loader (don't think it's clearly documented in the
> >Server Utils manual).
> >
> >If you specify a fix record length, SQL*Loader ignores CR's and read the
> >specified fix length number of bytes as a record.
> >
> >Eg.
> >LOAD DATA
> >INFILE 'foo.dat' "FIX 153"
> >APPEND INTO
> >TABLE scott.foo
> >(
> > col1 position(001:010),
> > col2 position(011:099),
> > etc..
> >)
> >
> >Of course if the datafile has a variable record length format, this will
 not
> >work.
> >
> >regards,
> >Billy
> >
> >
> Exactly, and since my file *does* contain variable length records, I'm outta
> luck (again).....
>
> Does anyone have a solution .... pleeeeeeaseeee??? (This is bugging the h...
> out of me, and seeing as we've got a project deadline to meet as well - that
> certainly doesn't make things any easier... B;-)

Perl with the DBI/DBD Oracle module. No "direct load" but can easily handle any arbitrary data then perform INSERT... instructions.

And, it's free!

http://www.perl.com for more details on Perl and all the archives. There are also links to places with more info on the database interfaces.

HTH!

--
Bill Meahan  wmeahan_at_ford.com
Ford Motor Company -- Operational Support Tools
Not an official statement of Ford Motor Company or anyone else
except the author.