| Zoned data Type [message #26470] |
Mon, 07 July 2003 10:27 |
Keshav Tripathy
Messages: 30
Registered: November 2001
|
Member |
|
|
Hi
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
02003042805120C
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.
Keshav
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
