field type

2001-11-14 Thread Example user SuSE Linux 6.2
Is it possible to use DBI to get the type of a field in a table? If so, how? The point is that I want to have a portable script along mysql and Oracle and these may have different datatypes. So it might be best to query the database what datatype fieldx is, then use it to say create an auxillia

DBI connection from Win to a remote Oracle

2001-10-05 Thread Example user SuSE Linux 6.2
Hi, I have not been able to find this on the DBI book or anywhere else I have a script that uses DBI to connect from a linux client to a mysql server on another linux machine via a connect( my $dbh=DBI->connect('DBI:mysql:database_name;host=172.16.160.8',) statement This runs fine. Now this ha