| Subject: | get_server_time with Oracle |
Hi,
get_server_time will not work under Oracle because of the missing " FROM
DUAL". I thought to make the change in
Data::ObjectDriver::Driver::DBD::Oracle sql_for_unixtime but then I
realized that this method is supposed to return an integer and not a
string so I made the following change
--- /home/sag/ROOT/lib/perl5/lib/perl5/TheSchwartz.pm.orig
2010-06-02 13:20:53.520219069 +0200
+++ /home/sag/ROOT/lib/perl5/lib/perl5/TheSchwartz.pm 2010-06-02
13:19:31.164714180 +0200
@@ -305,6 +305,7 @@
my TheSchwartz $client = shift;
my($driver) = @_;
my $unixtime_sql = $driver->dbd->sql_for_unixtime;
+ $unixtime_sql .=
$driver->dbd->isa('Data::ObjectDriver::Driver::DBD::Oracle') ? ' FROM
DUAL': '';
return $driver->rw_handle->selectrow_array("SELECT $unixtime_sql");
}
Regards,
-salih