UNIX shell command from ORACLE

Hi all,

Environment: ORACLE 7.3 on UNIX

I want to create a trigger on the table that fires each time the UPDATE or the SELECT statement is executed on this table. The trigger would run a stored procedure, which, in turn, would launch the program on UNIX. How do I execute a UNIX command from a stored procedure?

I have implemented exactly the same scenario using MS SQLServer on NT. The line that executed NT system command from a stored procedure looked like this: exec master..xp_cmdshell 'any_system_command' go

Is there a similar way to execute system commands from ORACLE stored procedures?

Thanks for the information.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet