OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » dos2unix

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

dos2unix [message #564130]

Tue, 21 August 2012 09:41

primer2020
Messages: 32
Registered: August 2012

Member

Hello,
How can I call the dos2unix utility from Oracle ?

I'm building an external table in a procedure where each time the latter is called the file name(s) are different.
any ideas ?

Thank you

Report message to a moderator

Re: dos2unix [message #564131 is a reply to message #564130]

Tue, 21 August 2012 09:43

Michel Cadot
Messages: 54236
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why do you want to call dos2unix and what is the relation with an external table and the file name(s)?

Regards
Michel

Report message to a moderator

Re: dos2unix [message #564132 is a reply to message #564130]

Tue, 21 August 2012 09:43

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>How can I call the dos2unix utility from Oracle ?
with difficulty!
consider do so from the script that places the file onto the local OS file system.

Report message to a moderator

Re: dos2unix [message #564133 is a reply to message #564130]

Tue, 21 August 2012 09:47

primer2020
Messages: 32
Registered: August 2012

Member

These are two seperate and relate questions Smile

The dos2unix untility is clean the file before loading into an external table..
The file names changes on regular basis...
Thank you

Report message to a moderator

Re: dos2unix [message #564134 is a reply to message #564133]

Tue, 21 August 2012 09:54

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>The file names changes on regular basis...
soft link to known file name that PL/SQL procedure always uses

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: dos2unix [message #564135 is a reply to message #564133]

Tue, 21 August 2012 09:55

John Watson
Messages: 3113
Registered: January 2010
Location: Global Village

Senior Member

Specify dos2unix in the PREPROCESSOR clause of your CREATE TABLE statement.

Report message to a moderator

Re: dos2unix [message #564141 is a reply to message #564135]

Tue, 21 August 2012 11:12

Michel Cadot
Messages: 54236
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

... if you are in 11g. Wink

Regards
Michel

Report message to a moderator

Re: dos2unix [message #564142 is a reply to message #564133]

Tue, 21 August 2012 11:13

Michel Cadot
Messages: 54236
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

These are two seperate and relate questions

2 separate questions => 2 topics otherwise it is a mess.

Quote:

The file names changes on regular basis...

And ALTER TABLE changes it as well for your table.
Database SQL Reference

Regards
Michel

Report message to a moderator

Previous Topic:	how to create a directory on init.ora file?
Next Topic:	merge on view

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 18:13:37 CDT 2013

Total time taken to generate the page: 0.47227 seconds