| ROWID Error? [message #373742] |
Thu, 03 May 2001 17:45  |
John LaViola
Messages: 1
Registered: May 2001
|
Junior Member |
|
|
Can anyone help me with this...I am confused as to why I am getting the problem described below.
Thanks.
Suddenly the database does not return proper quantity of records when my SQL statement is based on ROWID identification of record. The followed statement was executed through SQL*Plus and KeepTool...same result
Example 1:
SELECT F1,F2,F3,F4
FROM JOBS
WHERE
RowId='AAAAq7AAJAAALDGAAe' OR
RowId='AAAAq7AAJAAALDGAAZ' OR
RowId='AAAAq7AAJAAALDGAAd' OR
RowId='AAAAq7AAJAAALDGAAV' OR
RowId='AAAAq7AAJAAALDGAAf' OR
RowId='AAAAq7AAJAAALDGAAg' ;
This Statement returns only one record. But nevertheless ALL records do exist!
Example 2:
SELECT F1,F2,F3,F4
FROM JOBS
WHERE
RowId IN ('AAAAq7AAJAAALDGAAe' ,
'AAAAq7AAJAAALDGAAZ' ,
'AAAAq7AAJAAALDGAAd' ,
'AAAAq7AAJAAALDGAAV' ,
'AAAAq7AAJAAALDGAAf' ,
'AAAAq7AAJAAALDGAAg' );
This Statement also returns only one record.
Who knows what is the problem can be and how it can be fixed ??
Is this potentially related to some internal feature? All data is there, we just can't access via ROWID.
|
|
|
|
| Re: ROWID Error? [message #373743 is a reply to message #373742] |
Thu, 03 May 2001 18:27  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
It works fine with me on 8.1.5. I guess it's obvious, but the rowid can change over time for the same rows if there's the table's been moved, re-imported etc. Are those rowid's freshly queried? Select the rowid too to see if it's always only the first specified rowid which is returned.
select * from abc where rowid in (select rowidtochar(rowid) from abc)
select * from abc where rowid in
('AAABy4ABQAAABLrAAA',
'AAABy4ABQAAABLrAAB',
'AAABy4ABQAAABLrAAE',
'AAABy4ABQAAABLrAAD')
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
