Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2004
    Posts
    4

    Unanswered: Host command from a trigger

    HI
    I'm looking for a sample script to issue a HOST command from a trigger.

  2. #2
    Join Date
    May 2006
    Posts
    132
    HOST is a SQL*Plus command.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    That being said, you can run a host command from a trigger if you setup an external procedure or a java procedure that calls system.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Yep there is a nice java proc on asktom called run_cmd I think.

    Alan

  5. #5
    Join Date
    Oct 2006
    Posts
    1
    This link may be of use to you. It shows how to execute an os command from any plsql.

    http://www.astral-consultancy.co.uk/...doco.cgi?11160


Posting Permissions

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