Re: Run os commands from a stored procedure?
From: Mark Malakanov <markmal_at_delete-this-antispammer.home.com>
Date: Mon, 23 Apr 2001 18:40:02 GMT
Message-ID: <6G_E6.36045$_P.10122651_at_news3.rdc1.on.home.com>
Date: Mon, 23 Apr 2001 18:40:02 GMT
Message-ID: <6G_E6.36045$_P.10122651_at_news3.rdc1.on.home.com>
You can go other way.
Create table for messages.
Create procedure to "send" mesages - just insert into this table.
Make a separate perl script. Schedule this script into crontab. This perl
script will connect to database, read table, send message and optionally
delete/change status of message row.
-- ----------------------------------------------------- Thanks, Mark "Lee Miller" <lpm_at_newsguy.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:9c1p6c0ov0_at_enews3.newsguy.com...Received on Mon Apr 23 2001 - 20:40:02 CEST
> Is it possible with Oracle 7.3.x to run a OS command from inside a stored
> procedure? Basically I want to homebrew an answer to SQL Server's
> xp_sendmail using a stored procedure that will create the message as a
text
> file and then call perl to execute the SMTP transfer from the RDBMS's host
> OS (Solaris 8 in this case). Can this be done using DBMS_SQL or any other
> packages?
>
>