Link to home
Start Free TrialLog in
Avatar of KathysFriend
KathysFriendFlag for Canada

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
Avatar of Sean Stuber
Sean Stuber

Steven Feurstein has an excellent example of invoking an external DLL here

http://www.toadworld.com/BLOGS/tabid/67/EntryId/228/How-to-Run-an-OS-Command-from-PL-SQL.aspx
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
Avatar of KathysFriend

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?
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you