Is there any way in ORACLE8i /on HPUX to launch the operating system level command using PLSQL .
I am trying to accomplish the following
 copy a text file from one directory to another directory
 Open the text file useng PL/SQL and read the file line by line and store it into the database table
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.
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
Click Here to Expand Forum to Full Width