calling an exe from oracle stored procedure


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: calling an exe from oracle stored procedure

  1. #1
    lata Guest

    calling an exe from oracle stored procedure


    hi,
    Couid you please tell me Is it possible to call an executable file from

    an oracle stored procedure.

    Thanks in Advance,
    lata


  2. #2
    Matthew Cromer Guest

    Re: calling an exe from oracle stored procedure


    "lata" <shobalatharaju@epatra.com> wrote:
    >
    >hi,
    >Couid you please tell me Is it possible to call an executable file from
    >
    >an oracle stored procedure.
    >
    >Thanks in Advance,
    >lata
    >


    It is indirectly possible. What you need is another application to open
    a socket port on the target machine. When the listener app receives a specific
    message, launch your desired application.

    The Oracle SO can be written in Java, and use the Java socket / networking
    libraries to send a message to the triggering EXE.

    If you were not running the Java inside Oracle you could simply use JNI to
    invoke the EXE via a createprocess call to the Win32 API, but Oracle's JVM
    (Aurora) won't allow you to make JNI calls.

    Matthew Cromer


  3. #3
    Raghu Guest

    Re: calling an exe from oracle stored procedure


    You can not call an EXE from a Stored procedure directly.
    You have to convert your exe into a library file first and then
    register your functions in the dll as external functions in Oracle.

    Then you can access the functions in the library from SP's.

    Refer to Oracle Programmers reference for more information.

    Regards
    Raghu


    "lata" <shobalatharaju@epatra.com> wrote:
    >
    >hi,
    >Couid you please tell me Is it possible to call an executable file from
    >
    >an oracle stored procedure.
    >
    >Thanks in Advance,
    >lata
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center