KathysFriend
asked on
sample pl/sql program to call a c dll and e-mail program on a windows platform
Looking for a sample pl/sql program to call a c dll and e-mail program on a windows platform
I've never done anything like this before
I've never done anything like this before
the specifics of how to declare and invoke an email routine from your DLL will depend on the specification of that routine. If you can post the api I can help with the pl/sql syntax declarations
Note, you don't need external routines to send email from oracle, beginning with 8i you could use UTL_SMTP. Starting with 10g you can use UTL_MAIL which offers limited functionality for email but in a more convenient syntax than utl_smtp
ASKER
Actually I do use UTL_MAIL without issue.
What I have is Oracle 11g on a Unix server with the application on a Windows server. There is a C dll on the application server - can I call that from pl/sql?
What I have is Oracle 11g on a Unix server with the application on a Windows server. There is a C dll on the application server - can I call that from pl/sql?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
http://www.toadworld.com/BLOGS/tabid/67/EntryId/228/How-to-Run-an-OS-Command-from-PL-SQL.aspx