Re: DBI realted queries

[Eternius]

Nilay Puri wrote:
Hi all,

$sth->{LongReadLen} = 30000;  #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, $PASSWORD)||
die $DBI::errstr;
	my $sth = $dbh->prepare($sqlstmt);
	$sth->{LongReadLen} = 30000;  

	$sth->execute();	

        $sth->bind_columns(undef, \($id_prod)) ; #where do i find detials of
function bind_columns OR what is bind_columns doing over here ?
Thanks,
Nilay


http://search.cpan.org/~timb/DBD-Oracle-1.15/Oracle.pm

generally at cpan.org

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>