Home » Infrastructure » Other Operating Systems » Equivalent of ZONED(SQLLOADER) in PL/SQL
Equivalent of ZONED(SQLLOADER) in PL/SQL [message #43303] Fri, 04 July 2003 01:45 Go to next message
Keshav Tripathy
Messages: 30
Registered: November 2001
I have a scenerio in which I am Loading the Mainframe Data (Text File) to Oracle Tables using ZONED Data Type in the SQL LOADER Control Files. I need to do the same Data Loading using UTL_FILE Package of PL/SQL. What I need to do to take care of Replacing ZONED Statement of SQLLOADER in my PL/SQL CODE.

Example: The Mainframe Text File Looks like this

The Control File (SQLLOADER) Statement is as follows.

X Position(1:15) ZONED(15,0)

This is working perfectly allright and Data is Correctly Loaded to the Oracle Tables.

But I need to do the Data Load using UTL_FILE so how can I achieve the same.

Thanks to all of you.

Re: Equivalent of ZONED(SQLLOADER) in PL/SQL [message #43343 is a reply to message #43303] Tue, 08 July 2003 19:25 Go to previous message
Messages: 130
Registered: May 2003
Senior Member
let me if fix this problem in pl/sql, just please post the eg: here, I am also doing research on it.
Previous Topic: Zoned data Type
Next Topic: logminer performs like a dog when multiple archve logs specified
Goto Forum:

Current Time: Tue Jun 15 05:38:18 CDT 2021