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

    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?

    Thanks,

    -Tom
    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
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    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
    http://asktom.oracle.com
    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
    Location
    Berkshire, UK
    Posts
    186
    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
  •