OraFAQ Forum: SQL & PL/SQL » Invailad row id , ora-01410

Home » SQL & PL/SQL » SQL & PL/SQL » Invailad row id , ora-01410 (Oracle8i ,Oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Invailad row id , ora-01410 [message #378720]

Wed, 31 December 2008 22:38

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

Report message to a moderator

Re: Invailad row id , ora-01410 [message #378723 is a reply to message #378720]

Wed, 31 December 2008 23:07

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

Report message to a moderator

Re: Invailad row id , ora-01410 [message #378732 is a reply to message #378723]

Thu, 01 January 2009 00:36

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Date function
Next Topic:	Calculate the exponenial moving average

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 19:26:54 CST 2024