Humberto - you will have to write a seperate procedure to do this, using either java or pro*c. if you are on 9 or later you could do it using the new scheduler, and just put a job in the scheduler to process a unix script (provided that you are running oracle on unix (linux)) as the script is executed on the server where oracle is running. If you use pro*c you would use something like dbms_pipe to communicate with oracle and pass to proc*c the script to be executed, which you then execute via the c call system( command ). If you make a java stored procedure use Runtime.getRuntime().exec( command ).
michael
-----Original Message-----
From: Humberto Alexandre V. Lima
[mailto:oracledba-ezmlmshield-x27096531.[Email address protected]
Sent: Thursday, December 29, 2005 1:46 PM
To: LazyDBA Discussion
Subject: [***SPAM***] - Calling Linux scripts from Oracle stored
procedures - Number of numbers in MIME From exceeds maximum threshold
Hi everybody
I am looking for documentation about how to call linux scripts from oracle
procedures, but could not find anything yet.
Can someone give a clue, is it possible? I am pretty much sure it is, donīt
know how.
In fact i need to convert files generated in a Linux enviroment to a windows
type file, I was will use the linux unix2dos aplication.
Thanks for any help.
Have a wonderfull 2006
Humberto
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page