DBI realted queries

2004-02-04 Thread Nilay Puri, Noida
Hi all, $sth-{LongReadLen} = 3; #what's the statement doing ? And from where to find out what all parameters are available to statement handle ? my ($id_prod); my $sqlstmt = EOM; SELECT id_prod FROM product EOM my $dbh = DBI-connect('DBI:Oracle:' . $SID, $USERNAME,

Re: DBI realted queries

2004-02-04 Thread Eternius
Nilay Puri wrote: Hi all, $sth-{LongReadLen} = 3; #what's the statement doing ? And from where to find out what all parameters are available to statement handle ? my ($id_prod); my $sqlstmt = EOM; SELECT id_prod FROM product EOM my $dbh = DBI-connect('DBI:Oracle:' . $SID,

Re: DBI realted queries

2004-02-04 Thread Wiggins d Anconia
Hi all, $sth-{LongReadLen} = 3; #what's the statement doing ? And from where to find out what all parameters are available to statement handle ? my ($id_prod); my $sqlstmt = EOM; SELECT id_prod FROM product EOM my $dbh = DBI-connect('DBI:Oracle:' . $SID,