Compativility error

[rguillen]

Hello,

I am using Oracle 8.1.7.0.0 in production and when run the next sentence "select last_call_et from SYS.V_$SESSION where sid = :sid" with TOracleDataSet component; run successfully, but if I run this sentence in Oracle 9.2.0.0 (in test) the following error appear "ORA-00942 table or view does not exist"

Can you tell me where is my error?

Thank you for your help.
Regards.

 

[Jens Fudickar]

I think it's a problem of privileges, not a problem of DOA.

Try the same statement with SQL*Plus and i think you get the same message.

You need more privileges. The difference will be the SELECT ANY DICTIONARY privilege.

Get it and it will work.

Greetings
Jens

 

[rguillen]

Hi,

Thanks for your help again.