This discussion is archived
0 Replies Latest reply: May 13, 2011 5:39 AM by user8720609 RSS

execute oracle procedure from sql to oracle getting error.

user8720609 Newbie
Currently Being Moderated
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 ..........

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points