Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: Call a Perl script from PL/SQL? (newbie question)

    I've been told it is possible to call extrnal programs from a PL/SQL command. What I need to do is to run a perl script (hopefully at a regular interval timed with DBMS_JOB).

    Can anyone help?


    P.S. extproc_perl isn't going to help us b/c we're on a Win2k server.
    P.P.S I'm really a dumb newbie so please make extensive use of sample code and explain what the code does. i.e. pretend you had to explain this to your mother.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    It is MUCH simpler to use Windoze AT command than to try to do it from inside the database.

    If you insist on doing it the hard way,
    go research using either EXTERNAL PROCEDURE or JAVA.

    go to
    and do a keyword search for examples of each.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2004
    Berkshire, UK
    if the task scheduler is no good I have an external dll that will run a batch file, so you can use utl_file.put_line to create the batch file then get oracle to make it run if thats of any use
    There are 10 types of people in the world, those that know Binary and those that don't.

Posting Permissions

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