Calling exe from Oracle Stored Procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Calling exe from Oracle Stored Procedure

  1. #1
    Join Date
    Jan 2003
    Posts
    9

    Calling exe from Oracle Stored Procedure

    Hi,
    I have an exe existing in NT environment and my oracle is existing in Solaris environment. Can anyone tell me if it is possible to call my exe from Oracle PL/SQL procedures? If Yes how can I do it.

    Thanks

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Write an an agent for NT that opens a connection to Oracle and waits for an alert. Call the exe after the alert comes.
    See the dbms_alert and dbms_pipe packages.
    The agent might by anything able to call exe (java, C, VB, .bat & sqlplus)
    Ales
    The whole difference between a little boy and an adult man is the price of toys

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width