Home » Infrastructure » Windows » Re: ORA-02041 Urgent!
Re: ORA-02041 Urgent! [message #100421] Fri, 20 December 2002 06:38
Scottt Hecht
Messages: 1
Registered: December 2002
Junior Member
I had the same problem when I was attempting to
access a remote database view -- via a database
link -- on one database to another. I was able to
eliminate it by adding the code

SET TRANSACTION READ ONLY;

before my SELECT statement to the view and
add

COMMIT;

after the SELECT statement. Hope this helps!

Report message to a moderator

Previous Topic: Re: Installing Developer 2000 and Oracle 7 on Windows 98
Next Topic: Install 8i problem!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 18:52:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.