Hello All,
When I call the tables attribute on my Oracle-DB I get an Error
ORA-00942: table or view does not exist. I connect as user sys when
calling this. I attached dbi->trace(4) of that call. Thanks any advice.
Martin
--
Martin Hesse [EMAIL PROTECTED]
nova ratio AG
Ransbach-Baumbach
Germany
[EMAIL PROTECTED] Tel. : 02623 92420 Fax. : 02623 9242100
-- As soon as you make something foolproof, someone will create a better
fool --
DBI 1.20-nothread dispatch trace level set to 4
Note: perl is running without the recommended perl -w option
-> tables in DBD::_::db for DBD::Oracle::db (DBI::db=HASH(0x5f593c)~0x60a028)
2 -> table_info for DBD::Oracle::db (DBI::db=HASH(0x60a028)~INNER)
3 -> prepare for DBD::Oracle::db (DBI::db=HASH(0x60a028)~INNER 'SELECT *
FROM
(
SELECT NULL TABLE_CAT
, decode( t.OWNER, 'PUBLIC', '', t.OWNER ) TABLE_SCHEM
, t.TABLE_NAME TABLE_NAME
, t.TABLE_TYPE TABLE_TYPE
, c.COMMENTS REMARKS
FROM ALL_TAB_COMMENTS c
, ALL_CATALOG t
WHERE c.OWNER (+) = t.OWNER
AND c.TABLE_NAME (+) = t.TABLE_NAME
AND c.TABLE_TYPE (+) = t.TABLE_TYPE
)
ORDER BY TABLE_TYPE, TABLE_S...')
New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x60a028), id=)
dbih_setup_handle(DBI::st=HASH(0x5f5984)=>DBI::st=HASH(0x5f5a50), DBD::Oracle::st,
5f5990, Null!)
dbih_make_com(DBI::db=HASH(0x60a028), DBD::Oracle::st, 208)
dbd_st_prepare'd sql SELECT
dbd_describe SELECT (EXPLICIT, lb 80)...
OCIErrorGet after OCIStmtExecute/Describe (er1:ok): -1, 942: ORA-00942: table or
view does not exist
ERROR EVENT 942 'ORA-00942: table or view does not exist (DBD ERROR:
OCIStmtExecute/Describe)' on DBI::st=HASH(0x5f5984)
!! ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR:
OCIStmtExecute/Describe)'
3 <- prepare= undef at Oracle.pm line 407
!! ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR:
OCIStmtExecute/Describe)'
2 <- table_info= undef at DBI.pm line 1087
<> DESTROY ignored for outer handle DBI::st=HASH(0x5f5984) (inner
DBI::st=HASH(0x5f5a50))
-> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x5f5a50)~INNER)
<- DESTROY= undef at DBI.pm line 1088
dbih_clearcom 0x5f5984 (com 0x5f5328, type 3) done.
!! ERROR: 942 'ORA-00942: table or view does not exist (DBD ERROR:
OCIStmtExecute/Describe)'
<- tables= ( ) [0 items] at test3.pl line 49
-> disconnect for DBD::Oracle::db (DBI::db=HASH(0x5f593c)~0x60a028)
<- disconnect= 1 at novaInfo_init.pm line 512
-- DBI::END
-> disconnect_all for DBD::Oracle::dr (DBI::dr=HASH(0x4689f0)~0x5f59b4)
<- disconnect_all= '' at DBI.pm line 468
-> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x60a028)~INNER)
<- DESTROY= undef during global destruction
dbih_clearcom 0x5f593c (com 0x5e32d8, type 2) done.
-> DESTROY in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0x5f59b4)~INNER)
<- DESTROY= undef during global destruction
dbih_clearcom 0x4689f0 (com 0x5c6ad8, type 1) done.
<> DESTROY for DBI::dr=HASH(0x4689f0) ignored (inner handle gone)
<> DESTROY for DBI::db=HASH(0x5f593c) ignored (inner handle gone)
