Front page | perl.dbi.users |
Postings from November 2001
> I have just installed the latest and greatest DBI-1.20.tar.gz and > DBD-Oracle-1.12.tar.gz and they cause Recordset to bomb out when opening > an Oracle database. I tested it on NT and Linux, both with the same > result - there are many error lines with error ORA-00942 saying the the > table or view is unavailable. > > With the old versions of DBI when you used ListTables it used to give > just a list of user tables. Now it gives thousands of tables, most of > them system tables, (2700+) and most of them are unavailable to the user. > > My guess is that there is different function that needs to be called to > get just the user tables, but I don't know what it is. > A quick workaround is to use the !Filter parameter to sort out only those tables you are interessted in. I CC this to the DBI list, maybe somebody there has a quick solution how to get the tables method only return the user tables, otherwise I have to dig deeper into this problem... Gerald ------------------------------------------------------------- Gerald Richter ecos electronic communication services gmbh Internetconnect * Webserver/-design/-datenbanken * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: richter@ecos.de Voice: +49 6133 925131 WWW: http://www.ecos.de Fax: +49 6133 925152 -------------------------------------------------------------