Home » RDBMS Server » Server Utilities » unix command from oracle (oracle 11.2.0.3 sun solaris 10.5)
unix command from oracle [message #600928] Thu, 14 November 2013 02:07 Go to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
hi

i load data from file to oracle through unix file system. file comes with ^mcharacter and to remove it we use dos2unix.
my load start whenever file arrive in director automatically so i want a system which can do dos2unix before running them. is there anyway we can run unix command from oracle interface.

please help
Re: unix command from oracle [message #600955 is a reply to message #600928] Thu, 14 November 2013 03:53 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> is there anyway we can run unix command from oracle interface.
Yes.
http://opreview.blogspot.com/2008/03/switching-between-plsql-java-and-shell.html
Though a little old, above article still holds good for the basics.

And in most cases, you actually need the other way around which is way simple.
Write a shell script to employ dos2unix and then load the data using oracle tools.
Previous Topic: Transforming Data During a Load (SQL*Loader) with SQL function
Next Topic: Field in data file exceeds maximum length
Goto Forum:
  


Current Time: Thu Mar 28 17:38:23 CDT 2024