CODEWITHSUNDEEP
perloracle-database
Bill
Bill

Reputation: 1247

How to access an Oracle database from Perl?

I'm converting some shell scripts to perl. All the database access is done using sqlplus. With perl is that a better way to access an Oracle database or should I just stick to sqlplus.

Upvotes: 2

Views: 13412

Answers (2)

PinkElephantsOnParade
PinkElephantsOnParade

Reputation: 6592

Here is a short example of usage of DBI:

use DBI;

$user = 'donny';
$password = 'ppp';
$dbconnectstring = 'basetest';
$dbh = DBI->connect('dbi:Oracle:',$user.'@'.$password,$dbconnectstring);

Also, note you can access sqlplus - or any command line - within a perl script. Just use backticks:

`cd dasd`

For example. Not sure if you'd want to do this, but just an idea, since you said you're converting shell to perl.

Upvotes: 3

Quentin
Quentin

Reputation: 944434

DBI is the standard Perl database interface (unsurprisingly, it has an Oracle driver). DBIx::Class wraps it with a nice ORM interface.

SQL Plus appears to be a command line interface to Oracle. To use it from Perl you would have to construct your queries by mashing strings together (a great way to introduce SQL injection problems), shell out to the command line client, then parse the text output. That is madness. Use an interface that gives you Perl data structures to work with.

Upvotes: 7

Related Questions