Home » SQL & PL/SQL » SQL & PL/SQL » Invailad row id , ora-01410 (Oracle8i ,Oracle9i)
Invailad row id , ora-01410 [message #378720] Wed, 31 December 2008 22:38 Go to next message
DRATHORE
Messages: 3
Registered: February 2008
Location: Kolkata
Junior Member

Dear All ,

I have problem with updating the table with rowed .

I get the row id form two tables join query .then I update the record of each table individual. That time I got the invalid row id error ora-01410.

When I getting the row id form one table and updating the record of this table that time
I have successfully updated the record.

please give the response ASAP

Thanks in Advance
D.Rathore

Re: Invailad row id , ora-01410 [message #378723 is a reply to message #378720] Wed, 31 December 2008 23:07 Go to previous messageGo to next message
DRATHORE
Messages: 3
Registered: February 2008
Location: Kolkata
Junior Member

It solve it,this is my mistake i h pass the rowid in varchar2(10) length , that is very shor for holding rowid.


Thaks to my senior sir Mr. Ram Garg
Re: Invailad row id , ora-01410 [message #378732 is a reply to message #378723] Thu, 01 January 2009 00:36 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Next time before posting read OraFAQ Forum Guide and:
- don't use IM speak
- copy and paste what you did and not just describe it.
- carfully read how to format your post

Reread your first post, how could we give you the solution you found with what you told us?

Regards
Michel
Previous Topic: Date function
Next Topic: Calculate the exponenial moving average
Goto Forum:
  


Current Time: Sat Dec 03 13:41:04 CST 2016

Total time taken to generate the page: 0.24283 seconds