Gordon,
thanks for the suggestion - it's obvious when pointed
out! it's a problems with compartmentalisation in my
head..
duh!
Ian
--- [EMAIL PROTECTED] wrote:
> 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
__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com