Computing.Net > Forums > Unix > Read win file from Unix pl_sql

Specialty Forums
Security and Virus
General Hardware
CPUs/Overclocking
Networking
Digital Photo/Video
Office Software
PC Gaming
Console Gaming
Programming
Database
Web Development
Digital Home

General Forums
Windows XP
Windows Vista
Windows 95/98
Windows Me
Windows NT
Windows 2000
Win Server 2008
Win Server 2003
Windows 3.1
Linux
PDAs
BeOS
Novell Netware
OpenVMS
Solaris
Disk Op. System
Unix
Mac
OS/2

Drivers
Driver Scan
Driver Forum

Software
Automatic Updates

BIOS Updates

My Computing.Net

Free IT eBook

Howtos

Site Search

Message Find

Data Recovery

Read win file from Unix pl_sql

Reply to Message Icon
Original Message
Name: Giuseppe77
Date: February 19, 2004 at 08:35:51 Pacific
Subject: Read win file from Unix pl_sql
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

Giuseppe77


Report Offensive Message For Removal


Response Number 1
Name: Jim Boothe
Date: February 19, 2004 at 09:24:17 Pacific
Subject: Read win file from Unix pl_sql
Reply: (edit)

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.


Report Offensive Follow Up For Removal

Response Number 2
Name: Giuseppe77
Date: February 20, 2004 at 00:40:41 Pacific
Subject: Read win file from Unix pl_sql
Reply: (edit)

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


Report Offensive Follow Up For Removal

Response Number 3
Name: FishMonger
Date: February 20, 2004 at 17:56:07 Pacific
Subject: Read win file from Unix pl_sql
Reply: (edit)

man dos2unix


Report Offensive Follow Up For Removal







Use following form to reply to current message: 

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Read win file from Unix pl_sql

Comments:
         

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL:
 
Data Recovery Software



Physical Memory Dump

Format/re-install Vista

Silent Hill 3 Help!

Virus alert in taskbar issue

continuous beeps unable to boot