How can I launch the operating system level command in ORACLE8i / HPUX using PL/SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How can I launch the operating system level command in ORACLE8i / HPUX using PL/SQL

  1. #1
    Join Date
    Mar 2002
    Posts
    18

    Question

    Is there any way in ORACLE8i /on HPUX to launch the operating system level command using PLSQL .

    I am trying to accomplish the following
    [1] copy a text file from one directory to another directory
    [2] Open the text file useng PL/SQL and read the file line by line and store it into the database table
    Please help.....

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Cool

    for point 1, i.e., for running an os command, either
    a. write a c program or
    b. write a java program and convert it into a java stored procedure.

    for point 2, use the UTL_FILE package for reading the text file.

    hth.
    Cheers!
    OraKid.

  3. #3
    Join Date
    Mar 2002
    Posts
    10
    you could also use utl_file to copy
    the file by opening and reading and
    writing it to a new directory. Make sure
    init.ora parameter for utl_file is set
    properly.

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