RE: can we call unix scripts from oracle database

From: <jim.silverman_at_thomson.com>
Date: Fri, 30 Mar 2007 09:18:37 -0400
Message-ID: <E2157B37A63D2E4B9B00575021FC84D6BE1968@tshusmian2msg01.ERF.THOMSON.COM>

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_at_thomson.com 
		
		From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of edwin devadanam
		Sent: Friday, March 30, 2007 8:15 AM
		To: Stefan Knecht; oracle-l_at_freelists.org
		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_at_gmail.com> wrote:
		Which database version ?
		
		Stefan
		On 3/30/07, edwin devadanam <edwin_kodamala_at_yahoo.com>
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.

--
http://www.freelists.org/webpage/oracle-l




application/octet-stream attachment: x1.sql



application/octet-stream attachment: x1.ksh

Received on Fri Mar 30 2007 - 08:18:37 CDT