There is only one instance of Oracle on the target machine, so no mistake
is
possible.
I'm trying to connect different ways.
Thanks a lot Ilya.
"Sterin, Ilya" wrote:
> Quick question, are you sure you are connecting to the right db. The
reason
> I ask, is if you have both production and development environments, which
I
> have here, you might make a mistake and connect to a different db wher
that
> table is empty, I've done that plenty of times before.
>
> Seems from the trace file, as if everything is going fine, though no
results
> are generated from your query? I'll look again.
>
> Ilya
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> To: Sterin, Ilya
> Cc: ''[EMAIL PROTECTED] ' '
> Sent: 9/20/01 8:55 AM
> Subject: Re: DBI use with DBD:Oracle module
>
> Hi Ilya
>
> I tried the changes you recommanded, and the result is still the same :
> i
> have
> no exception (die) thrown, the database handler is defined,
> but the query doesn't return anything (I tried under sqlplus, and the
> given
> table has records).
>
> Here is, as an attachment, the DBI log file.
>
> Please, help !!!!
>
> Thanks a lot
>
> "Sterin, Ilya" wrote:
>
> > First try to run this query in sqlplus to see if it's suppost to
> return
> > results, make sure to login with the same account used in the
> connect().
> >
> > Then put || die $DBI::errstr at the end of the connect call or call
> connect
> > like this...
> >
> > my $dbh= DBI->connect("dbi:Oracle:host=<host name>;sid=<sid>", $user,
> > $password, {RaiseError => 1});
> >
> > Just in case the call to connect fails.
> >
> > Also if none of the above give any clues, use trace() to dump a trace
> file.
> >
> > Put this before the call to connect
> >
> > DBI->trace(2, "trace.log");
> >
> > Then submit the trace.log to the list.
> >
> > Are you getting any error messages at all at this time? I assume, by
> your
> > message you are not, so it might simply be that no rows are returned.
> >
> > Ilya
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > To: Sterin, Ilya
> > Cc: '[EMAIL PROTECTED] '
> > Sent: 9/20/01 8:03 AM
> > Subject: Re: DBI use with DBD:Oracle module
> >
> > Here is the code I used for the connection to the database :
> >
> > my $dbh= DBI->connect("dbi:Oracle:host=<host name>;sid=<sid>", $user,
> > $password);
> > $dbh->{AutoCommit} = 0;
> > $dbh->{RaiseError} = 1;
> >
> > And the code of the select statement :
> >
> > my $query= "select type from productTypes";
> > my $sth= $dbh->prepare($query);
> > $sth->execute();
> >
> > my $rawRef;
> >
> > while(($rawRef= $sth->fetchrow_arrayref())) {
> > push(@choices, $rawRef->[0]);
> > }
> >
> > and the first call to the fetchrow_arrayref function returned "undef",
> > so
> > we never entered in the while loop.
> >
> > I also tried the following :
> >
> > my $query= "select type from productTypes";
> > $choices = $dbh->selectcol_arrayref($query);
> >
> > and the returned reference ($choices) points to an empty array.
> >
> > For information : the Oracle server is Oracle 8i
> > The release of DBI module is : DBI-1.14
> > The release of DBD::Oracle driver module is : DBD-Oracle-1.09
> >
> > Robert Jones told me to try "fetchrow_array" instead of
> > "fetchrow_arrayref"
> > , but the result is the same.
> >
> > Thank you all for your help
> >
> > "Sterin, Ilya" wrote: Yes, I think everyone on this list has
> > experience:-)
> >
> > You need to give us a sample code as well as a little more info,
> before
> > we
> > can help, since as of right now, no one knows what you are doing
> wrong.
> >
> > Ilya
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> > Sent: 9/20/01 6:39 AM
> > Subject: DBI use with DBD:Oracle module
> >
> > Hi.
> >
> > I'm trying to use DBI with the DBD::Oracle driver.
> > The connection seems to work, but even a simple query like "select
> > col_name from table" doesn't return any record in the fetch.
> >
> > Does anyone have experienced the use of DBI with Oracle ???
> >
> > Thanks a lot
> >
> > Tewfik, a simple developper.
> > (See attached file: lokmane.vcf)
> > <<lokmane.vcf>>
> > <<lokmane.vcf>>
>
> DBI 1.14-nothread dispatch trace level set to 2
> Note: perl is running without the recommended perl -w option
> -> DBI->connect(DBI:Oracle:host=malabar;sid=aigle, lambda, ****,
> HASH(0x131d88))
> -> DBI->install_driver(Oracle) for perl=5.006 pid=16779 ruid=1042
> euid=1042
> install_driver: DBD::Oracle loaded (version 1.09)
> <- install_driver= DBI::dr=HASH(0x4d0990)
> -> connect for DBD::Oracle::dr (DBI::dr=HASH(0x4d0990)~0x5d9ba0
> 'host=malabar;sid=aigle' 'lambda' **** HASH(0x13342c))
> connect using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS
> =(HOST=malabar)(PROTOCOL=tcp)(PORT=1526))(ADDRESS
> =(HOST=malabar)(PROTOCOL=tcp)(PORT=1521))
> )(CONNECT_DATA=(SID=aigle)))' <- connect= DBI::db=HASH(0x5f8bdc) at
> DBI.pm line 408.
> -> STORE for DBD::Oracle::db (DBI::db=HASH(0x4fe45c)~INNER
> 'RaiseError'
> 1)
> <- STORE= 1 at DBI.pm line 433.
> -> STORE for DBD::Oracle::db (DBI::db=HASH(0x4fe45c)~INNER
> 'PrintError'
> 1)
> <- STORE= 1 at DBI.pm line 433.
> -> STORE for DBD::Oracle::db (DBI::db=HASH(0x4fe45c)~INNER
> 'AutoCommit'
> 0)
> <- STORE= 1 at DBI.pm line 433.
> <- connect= DBI::db=HASH(0x5f8bdc)
> -> prepare for DBD::Oracle::db (DBI::db=HASH(0x5f8bdc)~0x4fe45c
> 'select
> type from ProductTypes')
> fbh 1: 'TYPE' NO null , otype 1-> 5, dbsize 10/11, p10.s0
> <- prepare= DBI::st=HASH(0x4fe4d4) at OtsIhm.pm line 172.
> -> execute for DBD::Oracle::st (DBI::st=HASH(0x4fe4d4)~0x10b978)
> dbd_st_execute SELECT (out0, lob0)...
> dbd_st_execute SELECT returned (SUCCESS, rpc0, fn4, out0)
> <- execute= '0E0' at OtsIhm.pm line 173.
> -> fetchrow_array for DBD::Oracle::st
> (DBI::st=HASH(0x4fe4d4)~0x10b978)
> <- fetchrow_array= ( ) [0 items] at OtsIhm.pm line 177.
>
> (See attached file: lokmane.vcf)
> <<lokmane.vcf>>
(See attached file: lokmane.vcf)
lokmane.vcf
