Execute Unix command from a pl/sql procedure
Posted on 2004-10-12
The problem is related to error loging, when ever an exeception is raised in my procedure, I have to execute this unix command:
" logged -p local7.debug -t "DBA APPLICATION:" " FATAL TABLESPACE FULL"
This command only writes these words (DBA APPLICATION:" " FATAL TABLESPACE FULL) into a file, that file is watched by some guys, when ever there is a line inserted into that file (unix), they called the respected group (i.e., DBA) for this FATAL error.
I just want to do it via my stored procedure.
Help will be highly appreciate.