in reply to Identify host connected to in DBD::Oracle connection?

Would doing something like select host_name from v$instance; be any help?

Martin

Replies are listed 'Best First'.
Re^2: Identify host connected to in DBD::Oracle connection?
by AlephZarro (Novice) on Sep 28, 2009 at 16:50 UTC
    Doesn't seem to allow querying the v$ views 
    DBD::Oracle::db prepare failed: ORA-00942: table or view does not exis
+t (DBD ERROR: error possibly near <*> indicator at char 22 in 'select
+ host_name from <*>v$instance')

    [download]
[reply]
[d/l]

      You will need to get your DBA to grant read only access to v$. Something like:

      grant select on sys.v_$instance to yourusername

      Either get them to do it or consult the Oracle documentation

      Martin

[reply]
[d/l]

In Section Seekers of Perl Wisdom