Re: Using DBI for the first time...

Uhm, you're still not using DBI. This looks like oraperl or something similar. You can't miss DBI programs because right up at the top they say: use DBI;usually followed by something like: use DBD::Oracle; # for exampleWithout knowing what ora_fetch does, it's pretty much impossible to say what may be going wrong.

Comment on Re: Using DBI for the first time... Select or Download Code

Replies are listed 'Best First'.
Re: Re: Using DBI for the first time... by chipmunk (Parson) on Aug 21, 2001 at 01:49 UTC
It turns out that putting `use DBD::Oracle` at the top of the script is usually unnecessary. The DBI module will load the appropriate DBD module itself based on your connect string, e.g. `$dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd);`. Although there's no harm in loading DBD::Oracle explicitly, you only really have to do it when you want to use Oracle's type constants: `use DBD::Oracle qw(:ora_types);`	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re: Re: Using DBI for the first time...
by chipmunk (Parson) on Aug 21, 2001 at 01:49 UTC

use DBD::Oracle

$dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd);

Although there's no harm in loading DBD::Oracle explicitly, you only really have to do it when you want to use Oracle's type constants: use DBD::Oracle qw(:ora_types);

[reply]
[d/l]
[select]