Re: Calling external application

I needed to have a PL/SQL procedure send mail from an NT machine. For me, the simplest way was to fill a table of requests in the database and use it as a queue. Then, I set Oracle Enterprise Manager to run a job periodically which would

• query the queue to create a .bat file (SPOOLING from SQL*Plus)
• execute the .bat file
• purge the queue

Of course, this won't work for you if you don't want to wait until the next time the job fires.

Good luck!
- Catherine Devlin
http://profiles.yahoo.com/arcticturtle

In article <569a56d1.0106130141.1d22c5c1_at_posting.google.com>, Primoz Zavbi <primoz.zavbi_at_abit.si> writes:
>Hello.
>
>We are using oracle 8.0.5 database on WinNT.
>I need to call an external application (exe file) from an Oracle Trigger or
>Procedure.
>I think this is possible with external procedures, but you need
>to create library and other configurations.
>
>So if anybody has any advice how to make this call
>I would greatly appreciate.
>
>Primoz.

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net