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 v
- Original Message -
From: "Ian Carney" <[EMAIL PROTECTED]>
> I am trying to read v$ tables as system on a networked
> database, and get ora-942, table or view does not
> exist.
If you don't need to interpolate any variables in your SQL statement,
then use the single quote operator:
m
\$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
> networ
\$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
> networ
\$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
> networ
\$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
> networ
How about
$sql = "select * from v\$session";
- Original Message -
From: "Ian Carney" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 05, 2002 7:42 AM
Subject: reading v$ tables using dbi
> I am trying to read v$ tables as system
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
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
