-
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.....
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|