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

Reply via email to