Howto:Perl connection to Oracle

B

Bill

Anything out there that's well documented and half way easy to learn,
maybe even with some examples?

thanks in advance-
Bill
 
G

gf

Anything out there that's well documented and half way easy to learn,
maybe even with some examples?

thanks in advance-
Bill

the DBI is not that hard to use. Getting the connection going is the
first step and requires that you have the appropriate Oracle drivers
on the machine hosting the code, then getting the right settings to
plug into the DSN. You'll need the database name, the host name, the
port you're connecting to, the user ID and password, and to decide
whether you're going to let the DBI handle your error handling,
reporting and whether it should commit automatically.

Then, based on your application's needs, you'll want to get familiar
with do(), prepare(), execute() and selectrow_array() routines.

The DBI docs are pretty good and are mirrored in the "Programming the
Perl DBI" book from O'Reilly. I prefer the online docs at
http://search.cpan.org/~timb/DBI/DBI.pm though I regularly make a mess
of my monitor's screen highlighting sections and writing notes. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top