Invalid rowid

[Ole Kristian]

Hi!
I tried to update data in a row by using the command:
"select t.*, t.rowid from classrelation t order
by t.classid;"
and by unlocking the rows, edit the data and post the changes.

The error message I got was "Invalid rowid".
What's going on? When I used the standard
update

command, the operation was succesful. I use the 10.2 R2 Oracle version (both client and server).

 

[Marco Kalter]

Can you let me know your PL/SQL Developer version?

 

[Ole Kristian]

I'm using the 7.0.1.1066 version.

 

[Ole Kristian]

Update:
Sometimes I can update data and sometimes I can't. I haven't discovered the reason yet, but can it have something to do with the number of sqls I execute? Say, if I execute several sqls of the type:
"select t.*, t.rowid from classrelation t order
by t.classid;", but on different tables, the rowid is somehow corrupted? Can this be the case?

 

[Marco Kalter]

I can't imagine, but I will give it a try.