Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Read win file from Unix pl_sql
Name: Giuseppe77 Date: February 19, 2004 at 08:35:51 Pacific OS: win xp CPU/Ram: p4/512MB
Comment:
Hi all, I need some help. I must read a txt file create in windows o.s. from pl/sql Stored procedure (oracle 9i) on solaris o.s.Can you help me?thanks
Name: Jim Boothe Date: February 19, 2004 at 09:24:17 Pacific
Reply:
The init.ora file for the database has a parameter called utl_file_dir which is a list of directories that plsql can access.
You need to do an ascii transfer of your windows text file to one of these directories. You can then open that file with UTL_FILE.FOPEN, and you can read it with UTL_FILE.GET_LINE, etc.
0
Response Number 2
Name: Giuseppe77 Date: February 20, 2004 at 00:40:41 Pacific
Reply:
thanks for reply, but I do that.My problem is: Oracle(installed on Solaris) don't read the files because this is in win ascii format.There is a way, in pl/sql, to transform the files from win ascii format to unix asci format?
Giuseppe77
0
Response Number 3
Name: FishMonger Date: February 20, 2004 at 17:56:07 Pacific
Summary: How do i read binary files in Unix and as i know that counting the number of records in a file could be done using WC command, but how to use it for counting the number of records inside a binary file...
Summary: I want to use zmodem to download file from UNIX to Dos, what is the parameter (sz -? file ) that can specify the destination path such as " c:\download " . ...
0 
my script doesnt work in ...
