senget76 has asked for the wisdom of the Perl Monks concerning the following question:
Hi there
I am not sure how to explain this, must be a laugh material afterwards.
I want to connect to oracle database. to let you know, I not really know about oracle, the one I know is to do select and update statement.
When I try DBI, another problem arise. The perl script that I wrote is on other machine, and oracle on other machine. I heard about oracle client, but how to configure it so I could use it with DBI?, pls guide me
You need to install the Oracle client software, and configure the networking (tnsnames.ora file). Make sure you can connect using SQL*Plus first.
Once that is successful, make sure that DBI and DBD::Oracle are installed correctly (make test).
Then, post your script and the errors that you are receiving.
Good Luck!