Forum Stats

  • 3,733,252 Users
  • 2,246,738 Discussions
  • 7,856,634 Comments

Discussions

The OLE DB provider "OraOLEDB.Oracle" for linked server "XXXXX" reported an error. The provider ran

Nishant Baurai
Nishant Baurai Member Posts: 215
edited August 2017 in Heterogeneous Connectivity

I have Created a linked server in SQL Server to connect to Oracle database 12.1.0.2, test linked server is working fine and I can query the oracle tables, but when I am using the linked server in a stoerd procedure, I am getting below error.

Msg 7399, Level 16, State 1, Procedure <procedure_name>, Line 35

The OLE DB provider "OraOLEDB.Oracle" for linked server "XXXXX" reported an error. The provider ran out of memory.

Msg 7330, Level 16, State 2, Procedure <procedure_name>, Line 35

Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "XXXXX".

Regards,

Nishant

Best Answer

  • Nishant Baurai
    Nishant Baurai Member Posts: 215
    edited August 2017 Accepted Answer

    This issue is resolved for me.

    In the SQL Server, tried these steps:

    1. Click in the option Server Object.
    2. Click in Linked Servers.
    3. Click in Providers.
    4. Right click on OraOLEDB.Oracle and click Properties.
    5. enable Allow inprocess provider options.

    and it worked for me

Answers

  • Nishant Baurai
    Nishant Baurai Member Posts: 215
    edited August 2017 Accepted Answer

    This issue is resolved for me.

    In the SQL Server, tried these steps:

    1. Click in the option Server Object.
    2. Click in Linked Servers.
    3. Click in Providers.
    4. Right click on OraOLEDB.Oracle and click Properties.
    5. enable Allow inprocess provider options.

    and it worked for me

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,776 Bronze Crown
    edited August 2017

    Happy to see you found a solution. Please mark the thread as "Answered" so others will know too.

This discussion has been closed.