Help - dual table & synonyms in V7
Date: 15 Jul 93 16:14:18 GMT
Message-ID: <1993Jul15.151418.15261_at_lssec.bt.co.uk>
Having a bit of bother with the dual table :-(.
This may well be easy, but our DBA is away today, no-one in the office can help & the Oracle Response Centre has not yet called back.
I'm having problems selecting from the dual table from within forms, but the same select works OK from within Plus.
Statement is :- SELECT <seq>.nextval
INTO <variable> FROM sys.dual;
Also when I select FROM dual ( no owner name ) within plus I get ORA-980 : " synonym translation is no longer valid". Oerr offers no cause or action advice for this. I have dropped & recreated the public synonym for dual, and granted select to public, but still this problem persists.
Any ideas ?? Please reply by email.
Versions :- Oracle 7.1.12.1.0 Plus 3.1.1.9.1 PL/SQL 2.0.14.0.1 { maybe Forms 3.0.16.12.3 PL/SQL 1.00.36.02.02 { relevant ??
Ian A. Parkin
Home : twod_at_socrates.demon.co.uk
"I am not a uid, I am a free man. I refuse to be filed, sorted, piped
through uniq and grepped upon !"
Received on Thu Jul 15 1993 - 18:14:18 CEST