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