Hello:
I have a simple select query the works fine using DBD::Oracle
No bind_columns or params ...
$dbh = DBI->connect("dbi:Oracle:db7", "aname", "apasswd") or die;
my $sql = "SELECT STUFF, OTHERSTUFF from STUFF_TABLE";
my $sth = $dbh->prepare( $sql );
$sth->execute();
etc ...
However when I try to use the proxy (even on localhost) it fails.
What's the secret to Proxying Oracle? I did it a couple of years ago
but it doesn't seem to work now. I'm running Oracle 7.3.3 and have
the latest modules installed from CPAN.
Setting the connect string:
$dbh = DBI->connect("dbi:Proxy:hostname=thehost;port=3334;dsn=db7",
aname, apasswd) or die;
DBD::Proxy::st execute failed: Server returned error: Failed to execute method C
allMethod: Can't get DBI::ProxyServer::st=HASH(0x140533988)->{TYPE}: unrecognise
d attribute at /usr/local/lib/perl5/site_perl/DBI/ProxyServer.pm line 263.
Setting DBI_AUTOPROXY yields a different error:
DBI->connect(dbi:Proxy:hostname=thehost;port=5555;dsn=dbi:Oracle:db7) failed:
Missing hostname. at ./test line 14
Do I need to hold my jaw a certain way, or have I overlooked something simple?
Doing something stupid?
See daemon.log below
Feb 22 14:27:01 thehost DBI::ProxyServer[983]: Client executes method CallMethod
Feb 22 14:27:01 thehost DBI::ProxyServer[983]: CallMethod: => DBI::ProxyServer::
db=HASH(0x14051f978),prepare,SELECT STUFF, OTHERSTUFF from STUFF_TABLE,,ARRA
Y(0x1405323e8)
Feb 22 14:27:01 thehost DBI::ProxyServer[983]: Can't get DBI::ProxyServer::st=HA
SH(0x140533988)->{TYPE}: unrecognised attribute at /usr/local/lib/perl5/site_per
l/DBI/ProxyServer.pm line 263.
Feb 22 14:27:01 thehost DBI::ProxyServer[983]: Client executes method DestroyHan
dle
Feb 22 14:27:01 thehost DBI::ProxyServer[983]: Child terminating.
