Home » SQL & PL/SQL » SQL & PL/SQL » Calling Linux Command Using Pl/SQL (Oracle 10g and Suse Linux 64bit)
Calling Linux Command Using Pl/SQL [message #428240] Tue, 27 October 2009 09:36 Go to next message
gareths
Messages: 2
Registered: October 2009
Location: South Africa
Junior Member
Hi!

I need to create a trigger which will call a linux command. Basically, when a value changes in a table, I would like to run a linux script. The value in the table can change anytime during any day. I had a look at DBMS_JOB.SUBMIT but I'm not sure if this will work for me because I only need to run the linux script once - when the trigger is fired. I also don't wanna clutter the job queue. Please help. Thanx in advance.
Re: Calling Linux Command Using Pl/SQL [message #428243 is a reply to message #428240] Tue, 27 October 2009 09:42 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
google/search EXTERNAL PROCEDURE
Re: Calling Linux Command Using Pl/SQL [message #428249 is a reply to message #428243] Tue, 27 October 2009 09:49 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

A trigger that call's a shell script , ughhh
Re: Calling Linux Command Using Pl/SQL [message #428250 is a reply to message #428240] Tue, 27 October 2009 09:50 Go to previous message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at Database Change Notification

Regards
Michel
Previous Topic: PL/SQL Problem
Next Topic: VIEW
Goto Forum:
  


Current Time: Thu Sep 29 07:22:51 CDT 2016

Total time taken to generate the page: 0.12976 seconds