• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 776
  • Last Modified:

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
0
KathysFriend
Asked:
KathysFriend
  • 4
  • 2
1 Solution
 
sdstuberCommented:
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
0
 
sdstuberCommented:
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
0
 
sdstuberCommented:
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
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
KathysFriendDBAAuthor Commented:
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?
0
 
sdstuberCommented:
No, you can only call dll's that exist on the database server itself.

If you have a Samba or other network mount  point from the unix server to the windows server it might be possible since the dll would "appear" to be local to the db server.
0
 
KathysFriendDBAAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now