Home: Perl Programming Help: DBI:
oraperl to DBI



perluser2294
New User

Jan 19, 2016, 11:53 AM


Views: 25618
oraperl to DBI

I am working on upgrading Oraperl to DBI module.
I got a reference in another project where they created a wrapper class overriding oraperl functions.Please let me know if this is the right approach ,or is there any other way of doing?


FishMonger
Veteran / Moderator

Jan 19, 2016, 12:05 PM


Views: 25617
Re: [perluser2294] oraperl to DBI

I don't work with Oracle databases, but to do so via a perl script you should be using the DBD::Oracle module in conjunction with the DBI module.

http://search.cpan.org/~pythian/DBD-Oracle-1.74/lib/DBD/Oracle.pm


Laurent_R
Veteran / Moderator

Jan 19, 2016, 2:49 PM


Views: 25614
Re: [perluser2294] oraperl to DBI

The Oraperl library is obsolete (and was already considered obsolete last time I used it, about 12 or 13 years ago) and deprecated.

There is also an Oraperl module, using DBI and DBD::Oracle, an additional layer which makes it possible to use the old Oraperl syntax on top of DBI (I guess that's what you are thinking about), but it should be used only to allow existing Perl 4 oraperl scripts to run with minimal changes; any new development should use DBI directly.