Re: load from EBCDIC file to Oracle 9i tables using UTL

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 25 Feb 2005 11:20:44 +0100
Message-ID: <cvmu5t$n2l$1@news.BelWue.DE>

[snip]

I'm sorry, I don't have any EBCDIC files to test, but I'd strongly suggest to follow the track I suggested in my first answer: create an external table to pull the data into oracle. (You have read the threads at asktom, right?).

Now for writing, you'll have to dig into utl_file a bit, I'd be carefull about using any string datatypes and resort to raw if I was you. But this is only my guts feeling, I never had to get down that road.

>
> How do I resolve this? I would appreciate your help on this. This is
> something critical and immediate requirement for us.

Ooops, I fear, this is the wrong forum to ask then - that's what you pay support for.

>
> Thanks
> Karuna

HTH
Holger Received on Fri Feb 25 2005 - 04:20:44 CST

Re: load from EBCDIC file to Oracle 9i tables using UTL_FILE