DBI realted queries

[Nilay Puri]

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

[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

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

generally at cpan.org

[Wiggins D Anconia]

> 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 ?
>

perldoc DBI

that should explain everything. Alternatively you can look on
[url]http://search.cpan.org[/url] for the DBI docs in web form. There is also a
[email]dbi-users@perl.org[/email] list, but don't post there until you have read the
docs several times and haven't found what you are looking for as they
are very thorough.

[url]http://danconia.org[/url]