Call "host" from trigger ...

From: Kant Hung <kant.hung_at_everypath.com>
Date: 19 Jul 2001 14:28:21 -0700
Message-ID: <1dbe22ab.0107191328.3f816b7b@posting.google.com>

Hi all,

Sorry, I am still learning Oracle ...

All I want to do here is to execute a host command "dir" in this case when this trigger is activated ... it keep asking me to define "host".  Should "host" be already define in Oracle? Please help if you don't mind. Thank you.

Kant Hung
kant.hung_at_everypath.com

---

DROP PROCEDURE pay_salary2;

CREATE OR REPLACE PROCEDURE pay_salary2 ( sal float, fica float, sttax float, ss_pct float, espp_pct float) is
BEGIN
host ('dir');
END;
/

DROP TRIGGER Project_changes2;
CREATE OR REPLACE TRIGGER Project_changes2 AFTER DELETE OR UPDATE OR INSERT ON Project_tab

	FOR EACH ROW 
	CALL pay_salary2(6000.00, 0.2, 0.0565, 0.0606, 0.1)

/
Received on Thu Jul 19 2001 - 16:28:21 CDT