Accessing Oracle Using DBI

The official DBI::perl documentation web site contains the latest documentation.

SimpleQuery.pl is a program that can be run on any client machine that has DBI::Oracle installed. The Oracle client software must also be present, and $ORACLE_HOME and $TNS_ADMIN variables must also be set. Here is some sample output from this program:


%setup oracle
% SimpleQuery.pl
------------------------------------------- 
Simple jdbc query demonstration program     
you will be prompted for an oracle username,
password, SID name, and query.              
------------------------------------------- 
enter a SID:cdf_dev3
oracle userid:scott
oracle password:tiger
enter a query:select * from ped
CID | CHANNEL | OFFSET | O_ERROR | 
0 | 0 | 0 | 0 | 
1 | 1 | 1 | 1 | 
2 | 2 | 2 | 2 | 
% 




Dennis Box
Last modified: Tue Jan 5 22:56:45 CST