Edwin, attached to this message are two text files. The first, x1.sql, contains a snippet of PL/SQL code that will create a job, assign values to its arguments, and enable (i.e., call) it. The second, x1.ksh, contains the start of a shell script that could serve as the executable invoked by the database-generated job. This code lives in a 10.1.0.5 database on a Solaris host. A couple of things I learned along the way: * The environment for the process in which the executable file runs is virtually empty - not even a PATH variable exists - so you'll have to establish the environment on your own. * Depending on the platform on which the database resides, and the method by which the Oracle software was installed, you may encounter ORA-27369 errors (job of type EXECUTABLE failed with exit code ...). If so, consult Metalink for specific solutions based on your environment. <<x1.sql>> <<x1.ksh>> ===================================== Jim Silverman Senior Systems Database Administrator Solucient, LLC - A Thomson Company Telephone: 734-669-7641 FAX: 734-930-7611 E-Mail: jim.silverman@xxxxxxxxxxx From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of edwin devadanam Sent: Friday, March 30, 2007 8:15 AM To: Stefan Knecht; oracle-l@xxxxxxxxxxxxx Subject: Re: can we call unix scripts from oracle database Stefan, We have couple of 8i,9i and 10gR2 instances. useful updates have come and i would like to more about this. Could somebody provide be pratically applied scripts which are called from oracle database. thanks, Edwin.K Stefan Knecht <knecht.stefan@xxxxxxxxx> wrote: Which database version ? Stefan On 3/30/07, edwin devadanam <edwin_kodamala@xxxxxxxxx> wrote: Hi, Does anyone know how to call unix scripts from oracle database? Is it possible........or am i talking something alien..... regards, Edwin.K The fish are biting. Get more visitors <http://us.rd.yahoo.com/evt=49679/*http://searchmarketing.yahoo.com/arp/ sponsoredsearch_v2.php?o=US2140&cmp=Yahoo&ctv=Q107Tagline&s=Y&s2=EM&b=50 > on your site using Yahoo! Search Marketing. Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel <http://travel.yahoo.com/hotelsearchpage;_ylc=X3oDMTFtaTIzNXVjBF9TAzk3ND A3NTg5BF9zAzI3MTk0ODEEcG9zAzIEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--> to find your fit.