none
Linked Server Error (ORA-01410: invalid ROWID)

    Question

  • Hi All,

       Good Morning!!! I have a linked server setup for Oracle database and I am selecting rows from 3 views to insert into a table in SQL Server.The SELECT statement is failing with Following Error.

    OLE DB provider "MSDAORA" for linked server "xxxxxxxx" returned message "ORA-01410: invalid ROWID".

     

    Msg 7330, Level 16, State 2, Line 2

     

    Cannot fetch a row from OLE DB provider "MSDAORA" for linked server "xxxxxxxxx".

    Here is environment details:

    Operating System:  Windows Server 2003 R2 Enterprise

    SQL Server : SQL Server 2005 SP3 (9.0.4035)

    Does anyone face this issue in your environement?

    Looking forward for your reply.

    Thanks

    Pradeep


    Pradeep
    Wednesday, January 18, 2012 4:11 PM

Answers

  • Hi LMPradeep,

    >> OLE DB provider "MSDAORA" for linked server "xxxxxxxx" returned message "ORA-01410: invalid ROWID".

    Regarding to the error message you provided, which might be related to Oracle issue. A ROWID was entered incorrectly.  There are some related issue as yours, you can refer to the links below:
    1. http://ora-01410.ora-code.com/
    2. http://www.dba-oracle.com/t_ora_01410_invalid_rowid.htm

    If the community here failed to answer, you may try some database dedicated Oracle forum

    For how to set up and troubleshoot a linked server to an Oracle database in SQL Server, you can refer to this KB.

    Meanwhile, according to the query you mentioned the correct one should be looks like as below: 
    SELECT * FROM OPENQUERY(linked server name, 'SELECT name, id FROM table')

    More information, please refer to OPENQUERY (Transact-SQL)

    Regards, Amber zhang
    Friday, January 20, 2012 3:05 AM
    Moderator

All replies

  • This is not a SQL Server error. ORA-XXX errors are usually Oracle errors

     

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    Wednesday, January 18, 2012 4:17 PM
  • Thanks for your reply. But the same query if I run it from Oracle Server locally I can get the output.
    Pradeep
    Wednesday, January 18, 2012 4:28 PM
  • This linked server is working before or this is a new setup ?

    this seems a issue with query you have written using 3 views.

    Regards

    Rohit Garg

    Wednesday, January 18, 2012 4:34 PM
  • Here is the query format I am running.

    select

    (select newid()), *

    from

    openquery( XXXXXX,

    'select Query')

     

    I think the problem is with Hexa decemial value generation.

    Is ther any bug reported related to this problem?


    Pradeep
    Wednesday, January 18, 2012 5:20 PM
  • Hi LMPradeep,

    >> OLE DB provider "MSDAORA" for linked server "xxxxxxxx" returned message "ORA-01410: invalid ROWID".

    Regarding to the error message you provided, which might be related to Oracle issue. A ROWID was entered incorrectly.  There are some related issue as yours, you can refer to the links below:
    1. http://ora-01410.ora-code.com/
    2. http://www.dba-oracle.com/t_ora_01410_invalid_rowid.htm

    If the community here failed to answer, you may try some database dedicated Oracle forum

    For how to set up and troubleshoot a linked server to an Oracle database in SQL Server, you can refer to this KB.

    Meanwhile, according to the query you mentioned the correct one should be looks like as below: 
    SELECT * FROM OPENQUERY(linked server name, 'SELECT name, id FROM table')

    More information, please refer to OPENQUERY (Transact-SQL)

    Regards, Amber zhang
    Friday, January 20, 2012 3:05 AM
    Moderator