Another quick thing to check is: did you rebuild DBD::Oracle since upgrading?
Just checking...
Jeff
>
> On Jan 24, Spiraquis Alexis (SFO) scribed:
>
> > Hello
> >
> > I have on my server 5.005_03 built for sun4-solaris installed with
> > DBI(v1.13). I was previously accesing a Oracle 7.3.4
> Database without
> > problems. Now I tried to access the same DB but migrated to
> 8.1.7 and
> > I get the following error: DBD::Oracle::db prepare failed:
> ORA-00942:
> > table or view does not exist
> > (DBD: error possibly near <*> indicator at char 52 in '
> select m.swValue
> >
> > There is no "<*>" in my query and the same Perl page with
> Oracle 7.3.4
> > works. What I guess is that I use two types of connections.
> With this
> > type I don�t have any problems:
> > sub adv_connect
> > {
> > #local ($sql, @inputdata) = @_ ;
> >
> > local ($dbh) =
> DBI->connect('dbi:Oracle:dbname','user','pass',
> > );
> > $dbh->{AutoCommit} = 0;
> > return ($dbh);
> > }
> >
> > But with this type of connection I get the error mentioned
> above: sub
> > adv_connection {
> > local ($sql, @inputdata) = @_ ;
> > local ($dbh) =
> DBI->connect('dbi:Oracle:dbname','user','pass',
> > );
> > $dbh->{AutoCommit} = 0;
> > local ($sth) = $dbh->prepare($sql) or return ($dbh,undef);
> > $sth->execute();
> > $sth->bind_columns(undef, @inputdata);
> > return ($dbh, $sth);
> > }
> >
> > The question is: Do I need to change all these types of connections
> > and use the first one? Or I need to migrate the Perl or DBI
> version?
> > Thank you very much
> >
> >
> >
>
