I just want the info describing the table that I can see in sqlplus.
my $typz = q{ select column_name, data_type from use_tab_columns where table_name = ? }; my $sth = $dbh->prepare( $typz ); ... my $table = ... ; my %name2type = do { eval { my $a = $sth->fetchall_arrayref( $table ); @$a } } or die "Sorry, no data available for '$table'"; # at this point you either have a name->type map in # %name2type or died trying (e.g., due to bogus # column or database failure). -- Steven Lembark 85-09 90th Street Workhorse Computing Woodhaven, NY 11421 [EMAIL PROTECTED] 1 888 359 3508