Home Forums SQL Server 2005 SQL Server Newbies executing oracle procedure from sql server RE: executing oracle procedure from sql server

  • June 8, 2009 at 4:40 am

    #1005989

    I've used this for executing a MySQL proc from SQL Server, I presume similar will work for Oracle.

    EXEC('CALL usp_myProcedure(''2009-06-08 00:00:00'')') AT MySQLServer;

    Where MySQLServer is the name of your linked server.