Actually, that was my error, not Kevin's. It ended up being a typo on one
of the table names. I did not cut and paste from sqlplus into the DBI
script, I retyped it, and while reviewing the code several times, it took
someone else's eyes to see my mistake.
Thanks anyway,
-Mike
At 11:00 AM 09/18/2001, Mark Vandenbroeck wrote:
>Kevin,
>
>Your error is 'table or view does not exist'.
>Did you connect as the same Oracle user in SQL*Plus and perl ?
>
>Mark
>
>
>Kevin Bass wrote:
>
> > Please post your entire statement:
> >
> > my $sth = $dbh->prepare(qq(SELECT fuser.us_initl, . . .
> >
> > Thanks
> >
> > ----- Original Message -----
> > From: "Michael Ragsdale" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, September 17, 2001 3:00 PM
> > Subject: Oracle prepare failed?
> >
> > > I have a query that works just fine in Oracle SQL*Plus, but I receive the
> > > following error when run through DBI. Line 35 states:
> > >
> > > my $sth = $dbh->prepare(qq(SELECT fuser.us_initl,
> > >
> > > I'm running: Redhat 7.1,
> > > Perl 5.6.0,
> > > DBI 1.14,
> > > DBD::Oracle 1.06
> > >
> > > Here is the trace file:
> > >
> > > DBI 1.14-nothread dispatch trace level set to 2
> > > -> prepare for DBD::Oracle::db (DBI::db=HASH(0x81c17bc)~0x81c17ec
> > > 'SELECT fuser.us_initl,
> > > finventory.inumber,
> > > faccounttrans.at_amount,
> > > finventory.iposscasenumber,
> > > finventory.inotes
> > > FROM finventory,
> > > fpermittype,
> > > ...')
> > > !! ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR:
> > > OCIStmtExecute/Describe)'
> > > <- prepare= undef at cron.permit_replace.pl line 35.
> > > -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x81c175c)~INNER)
> > > <- DESTROY= undef at cron.permit_replace.pl line 66.
> > > -> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x81c17ec)~INNER)
> > > <- DESTROY= undef at unknown location!
> > > -- DBI::END
> > > -> disconnect_all for DBD::Oracle::dr
> > (DBI::dr=HASH(0x816e084)~0x81c1804)
> > > <- disconnect_all= '' at DBI.pm line 450.
> > > -> DESTROY in DBD::_::common for DBD::Oracle::dr
> > > (DBI::dr=HASH(0x81c1804)~INNER)
> > > <- DESTROY= undef during global destruction.
> > >
> > >
> > > -Mike
> > >
>
>--
>Mark Vandenbroeck Mobile : +32-495-59.55.62
>Business Process Manager Email : [EMAIL PROTECTED]
>EMEA Support Information Systems AIM : markvdb
