UTL_FILE problem - getting file in ascii format [message #112697] |
Mon, 28 March 2005 15:33 |
abeiko
Messages: 29 Registered: March 2005
|
Junior Member |
|
|
I am using utl_file to export table data into a flat file. However, the data is coming out in the "display" format. I need it to be in ascii format. Does anyone know of a conversion function I could use on the table columns ? Any help would be appreciated.
|
|
|
|
Re: UTL_FILE problem - getting file in ascii format [message #112815 is a reply to message #112697] |
Tue, 29 March 2005 08:59 |
abeiko
Messages: 29 Registered: March 2005
|
Junior Member |
|
|
Let me clarify... one field that is stored in the database as a number(4) is coming out in the flat file as '1'. I need it to be '000A' (without the quotes of course). Another example is '1940' should be 000000194} (with the bracket on the end).
Any ideas???
|
|
|
|