Equivalent Host Command in PL/SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Equivalent Host Command in PL/SQL

  1. #1
    Join Date
    Nov 2004
    Posts
    24

    Equivalent Host Command in PL/SQL

    Hi, I know how to spool from within a procedure by using the UTL_FILE package, so I am spooling a scripted file, now I want to trigger it from inside PL/SQL but I cannot use the HOST command, so what do I use??

    Help

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    os utilities - or use java in the database to run host commands

  3. #3
    Join Date
    Nov 2004
    Posts
    24
    Could you give me an example of OS utlities? I saw how to do it in Java and was trying to avoid that route, but I guess if I have to I will.

    Do you think someone already has a custom PL/SQL package or procedure to do this? Even if it's written in Java?

    Thanks

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you cant do od commands on pl/sql - its the simple.

    So either schedule an OS job (cron or win scheduler) or write some java which can do host calls. asktom.oracle.com has some examples

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