Executing Oracle Procedure from SQL7 Linked Server

• riveralf

  SSC-Addicted

  Points: 452

  More actions

  August 8, 2003 at 8:53 am

  #82204

  Hi all... I am triying to execute a Procedure in an Oracle instance from a SQL Server 7.0 Linked Server and I get this error message:

  Server: Msg 7212, Level 17, State 1, Line 3

  Could not execute procedure 'TEST' on remote server 'ORATEST'.

  [OLE/DB provider returned message: One or more errors occurred during processing of command.]

  Somebody can help me?...

  Thanks; Luis

  
  Luis F Rivera G
  Database Administrator
  MCSE, MCDBA, MCT

• August 11, 2003 at 8:00 am

  This was removed by the editor as SPAM

• HenryTr

  SSC Eights!

  Points: 845

  More actions

  August 14, 2003 at 11:02 am

  #469994

  Have you checked the Oracle server to make sure it is getting the request in the correct format?

• Strannik2002

  SSC Veteran

  Points: 279

  More actions

  August 19, 2003 at 3:48 am

  #470376

  I can be wrong but there's no way to call Oracle procedure from MSSQL directly. Microsoft advises to use trigger mechanism instead.