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

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

asktom is not at all free. Asking questions is not coming since he has lot of backlogs.

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

Well there was a logic given to convert varchar2 to Packed decimal, I want the reverse of the logic. Moreover in many place either using External tables or SQLLOADER, the programs treat the input files as fixed with as against variable length records we are getting. So the program should read the length of the record(and this is given in Packed decimal), and based on the value, it should read the rest of the data.  

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

Our team member have cracked this in Proc*C and in Java as well. I'm thinking if this is possible in PL/SQL itself.

> >
> > Thanks
> > Karuna
>
> HTH
> Holger
Received on Sun Feb 27 2005 - 23:45:42 CST