Databases in Perl

[webstony]

Hi everybody,

I have a question concerning perl. Because I am a Beginner in Perl- Programming, please excuse if my question is too simple, but I need your help.
Is it possible to work with Oracle Databases (maybe through the ODBC- Interface) in Perl? And if: Which commands do I have to use, for example to write something in an Oracle Database?

Thanks in advance,

webstony

 

[goBoating]

hello webstony,
it is possible to get to Oracle via ODBC, but, I believe the DBI/DBD modules provide a more direct route. The DBI (data base independent ) module provides a consistent base layer for the DBD (data base driver) modules to work on top off. You get the DBI module and an appropriate DBD module for the database you are working with. See

http://www.symbolstone.org/technology/perl/DBI/index.html

for a list of available DBD modules. Additionally, I would suggest that you take a look at "Programming the Perl DBI" by Alligator Descartes & Tim Bounce, published by O'Reilly ( about $35 US)....... well worth the read if your going to be playing these games. Lastly, while I have been away from it for a couple of years, I did use Perl for about 5 years talking to Oracle for scientific calculation and report generation chores. It is a solid tool. The DBI/DBD modules only make it better.

Good Luck.


keep the rudder amid ship and beware the odd typo