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
