Hi,

I'm new to perl and was wondering, if there is a way for me to write a script that will retreive the need info out of a unix server log file, and write it to the appropriate Table & Field in an Oracle DB.

This must sound crazy, but its to automate a process which is lengthy and forces users to cut & paste alot in excel.
Could I maybe do this using PL/SQL - instead of perl?

Thanks in advance for any guidance.

Yes. PL/SQL can read files (DBMS_OUTPUT package). Usually, the files it can read and write are in a controlled directory. V$PARAMETER view will tell you what the directory is. You will have to log into Oracle as oracle in order to read/write outside of that directory. Your DBA should be able to help you set things up.

If you use perl you have two choices: use DBI in perl to connect to the db, and then read the file and insert. Or create a well ordered file you can use with sqlldr.

One other option: sqlldr all by itself. Read up on the control file options for reading a text file, specifying record layouts, etc.