Home » SQL & PL/SQL » SQL & PL/SQL » Calling Win32 files ( EXE or DLL) from PL/SQL
Calling Win32 files ( EXE or DLL) from PL/SQL [message #197491] Wed, 11 October 2006 08:02 Go to next message
gd001
Messages: 3
Registered: August 2006
Junior Member
Hi,

I need to call a Win32file ( can be an Exe and a dll) from PL/SQl code..I need to get the results back to the calling PL/SQL code for furthur processing. Is there a an Implementation way to do this from PL/SQL?.

Let me know at the earliest

Thanks
Re: Calling Win32 files ( EXE or DLL) from PL/SQL [message #197492 is a reply to message #197491] Wed, 11 October 2006 08:13 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Reported message said:

Reason Needed some quick response.. Doing it in the hope if the moderator can be of use for some escalations...this is not a common issue and I am not sure if people have used it as well.


Please do not report messages to get answers.
Re: Calling Win32 files ( EXE or DLL) from PL/SQL [message #197505 is a reply to message #197492] Wed, 11 October 2006 08:56 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I believe a java stored procedure can run host commands on the server. I'm not sure though...

MHE
Re: Calling Win32 files ( EXE or DLL) from PL/SQL [message #197506 is a reply to message #197505] Wed, 11 October 2006 08:58 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can use OCI to do it.
Re: Calling Win32 files ( EXE or DLL) from PL/SQL [message #197599 is a reply to message #197506] Wed, 11 October 2006 23:28 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi!
i've created before using tnsping in pl/sql check if this can help.


  • Attachment: deploy.sql
    (Size: 1.79KB, Downloaded 936 times)
Re: Calling Win32 files ( EXE or DLL) from PL/SQL [message #197743 is a reply to message #197491] Thu, 12 October 2006 08:54 Go to previous message
gd001
Messages: 3
Registered: August 2006
Junior Member
Thank you for all your help Folks.
Previous Topic: How to store binary file(any file) in BLOB field in oracle 8i.
Next Topic: sql query
Goto Forum:
  


Current Time: Thu Dec 08 16:26:23 CST 2016

Total time taken to generate the page: 0.10112 seconds