|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
July 12th, 2003, 08:54 PM
|
|||
|
|||
|
Viewing Oracle tables from a remote computer
I am trying to view information in an Oracle database using a perl script, but it is not working. I was trying to install DBD::Oracle thinking that was the problem, but now I am not so sure. (another thread on the errors in the perl forum.)
Can anyone tell me what modules you need to view Oracle tables? I wouldn't think i would need the complete Oracle installed? I have DBI installed, & am able to view MySQL tables fine. I am also using the same query code as SQL, I am assuming it should work the same? Code:
#!/usr/bin/perl -w
use CGI ':standard';
use DBI;
my $dbh = DBI->connect('DBI:Oracle:xxx.xxx.xxx.xxx', '$user', '$pass');
$sth = $dbh->prepare("SELECT * FROM $table");
$sth->execute();
|
|
#2
July 13th, 2003, 11:07 PM
|
|||
|
|||
|
You need the DBI and you will need at least the Oracle client files since the the perl will be using the OCI. If you were using Java you could use the thin and would only need the classes.zip file.
|
|
#3
July 14th, 2003, 04:31 AM
|
|||
|
|||
|
Thanks! What are the oracle client files?
|
|
#4
July 15th, 2003, 02:50 PM
|
|||
|
|||
|
You will need to install the Oracle network libraries. These can be obtained from
http://otn.oracle.com/software/content.html
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Viewing Oracle tables from a remote computer |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
