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