are the usernames used in dbi the same as in sqlplus?
Since it is a ORA-00942 error, it is possible that
1. the user connected through dbi does not own the table
2. there is no synonym created for the dbi user so that tables have to be
qualified as
schema.table_name
3. there is no select privilege granted to the dbi user on one of the tables
> Dong Wang
> Grand Central Networks
> [EMAIL PROTECTED]
-----Original Message-----
From: Michael Ragsdale [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 12:01 PM
To: [EMAIL PROTECTED]
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
