Perl is probably reading v$table as v(contents of the scalar $table).
Try using an escape character.  v\$table

Gordon

-----Original Message-----
From: Ian Carney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 7:42 AM
To: [EMAIL PROTECTED]
Subject: reading v$ tables using dbi


I am trying to read v$ tables as system on a networked
database, and get ora-942, table or view does not
exist.

I can access these tables using SQL*Plus from the same
machine over the lan, and the "system" user can access
non v$tables via DBI.

Any ideas??

the database version is 9.0.1

thanks

Ian

__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com

Reply via email to