0 Replies Latest reply: May 13, 2011 7:39 AM by user8720609 RSS

    execute oracle procedure from sql to oracle getting error.

    user8720609
      Dear all,

      when we execute the oracle procedure from sql server to oracle using oracle OLE/DB that time given below error.

      EXEC TEST.GENNEWUAT.INS.PROC_TEST_CDBG 'ABC', 'ABC'

      Server: Msg 7399, Level 16, State 1, Line 1
      OLE DB provider 'OraOLEDB.Oracle' reported an error.
      [OLE/DB provider returned message: Unspecified error]
      OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' ICommandText::SetCommandText returned 0x80004005:].

      PLEASE HELP ME ON ISSUE ..........