Home » RDBMS Server » Server Administration » ROWID error
ROWID error [message #373157] Fri, 30 March 2001 04:06 Go to next message
stephen davies
Messages: 2
Registered: March 2001
Junior Member
Can anyone help, I am getting an invalid rowid error selecting from a table in my database that has been automatically loaded with data from an outside soure. I decided to check the format of the rowids using select rowidtochar(rowid) from table and some of them contain charcters + and / is this valid as I thought that the rowid is a hex number?

Report message to a moderator

Re: ROWID error [message #373158 is a reply to message #373157] Fri, 30 March 2001 06:28 Go to previous messageGo to next message
John R
Messages: 156
Registered: March 2000
Senior Member
Having had a quick poke about in our database, we have valid rowids with '+' and '/' in them.
Where are you getting the rowid from when you do the selection?
If the data has been imported from another source then the new rowids will not be the same as the originals.

Report message to a moderator

Re: ROWID error [message #373159 is a reply to message #373158] Fri, 30 March 2001 06:59 Go to previous message
stephen davies
Messages: 2
Registered: March 2001
Junior Member
Thats great thanks I just wanted to check if + and / where valid characters in the rowid value.

Report message to a moderator

Previous Topic: Re: DECODE function
Next Topic: COPY command failure, ORA : 01043 user side memory corruption [string], [string], [string], [string]
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 15:57:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.