Hi. I posted this question to the author of JDBC and he proposed that I
post it here.
I'm trying to execute the following code:
#!/usr/bin/perl
use JDBC;
use strict;
JDBC->load_driver("oracle.jdbc.driver.OracleDriver");
my $url = "jdbc:oracle:thin:haha/[email protected]:1521:lsd1";
my $con = JDBC->getConnection($url);
my $sql = "SELECT TABLE_NAME FROM USER_TABLES";
my $ps = $con->prepareStatement($sql);
my $rs = $con->executeQuery();
while ($rs->next) {
my $foo = $rs->getInt(1);
my $bar = $rs->getString(2);
print "row: foo=$foo, bar=$bar\n";
}
And I get the following error:
lsnas003 # perl ./haha
You are not allowed to invoke method prepareStatement in class
oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not
access a member of class oracle.jdbc.driver.PhysicalConnection with
modifiers "public synchronized" at (eval 56) line 927
at ./haha line 12
Any thoughts?
TIA,
Jeff