Is this OROWID a column in your table or is it just a typo? Tanel.
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 5:59 PM > > Hi All, > > I am facing one problem explained below: > Our application is using a trigger on view a based on some table b. > > IF :new.IND = 'Y' THEN > UPDATE b set > IND = NVL(RTRIM(:new.DIND),' ') > WHERE ROWID = :old.OROWID; > END IF; > Apllication is trying to update view, nad thus triiger consist above > statement got fired. > > The above statement giving error : > ORA-01410: invalid ROWID > > have any body faced the same problem earlier. > We are using : > > Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production > PL/SQL Release 9.2.0.2.0 - Production > CORE 9.2.0.2.0 Production > TNS for IBM/AIX RISC System/6000: Version 9.2.0.2.0 - Production > NLSRTL Version 9.2.0.2.0 - Production > > > With Regards, > Manoj Kumar Jha > > -------------------------------------------------------------------------- ------ > > -------------------- > A transcendentalist engaged in auspicious activities does not meet with > destruction either in this world or in the spiritual world; one who does > good, > is never overcome by evil. > -------------------------------------------------------------------------- ------ > > -------------------- > > DISCLAIMER: The information contained in this message is intended only and > solely for the addressed individual or entity indicated in this message and > for the exclusive use of the said addressed individual or entity indicated > in this message (or responsible for delivery of the message to such person) > and may contain legally privileged and confidential information belonging > to Tata Consultancy Services. It must not be printed, read, copied, > disclosed, forwarded, distributed or used (in whatsoever manner) by any > person other than the addressee. Unauthorized use, disclosure or copying is > strictly prohibited and may constitute unlawful act and can possibly > attract legal action, civil and/or criminal. The contents of this message > need not necessarily reflect or endorse the views of Tata Consultancy > Services on any subject matter. Any action taken or omitted to be taken > based on this message is entirely at your risk and neither the originator > of this message nor Tata Consultancy Services takes any responsibility or > liability towards the same. Opinions, conclusions and any other information > contained in this message that do not relate to the official business of > Tata Consultancy Services shall be understood as neither given nor endorsed > by Tata Consultancy Services or any affiliate of Tata Consultancy Services. > If you have received this message in error, you should destroy this message > and may please notify the sender by e-mail. Thank you. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: ManojKr Jha > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
