upload a file by oracle store procedure using utl_file package.

**Mahmoud ALsaadi** · Jan 12 '12, 05:01 AM

I want to upload a text.txt file through oracle store procedure using utl_file package.

Sample
Open OS file
utl_file.fopen( filename)
Close OS file
utl_file.fclose

the text.txt content:

QRIFR6M Index,BID,0.787 5
QRIFR9M Index,BID,0.862 5
QRIFR1Y Index,BID,0.975
QRIFROVN Index,ASK,0.743 75
QRIFR1W Index,ASK,0.781 25
QRIFR1M Index,ASK,0.906 25

Its Urgent for me,
Regards and Thanks