[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 775
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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