Re: How can I run an Oracle stored procedure from SQl Server

From: Matt (idontwanttobespammed_at_noreply.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 08:26:35 GMT

Create a linked server in SQL Enterprise manager.
Select * from OpenQuery(LinkedServerName, 'Oracle sqlstatement');

/M

"Mark Andrews" <NOSPAMmandrews@rptsoftware.com> skrev i meddelandet
news:ukBDcu9TEHA.2408@tk2msftngp13.phx.gbl...
> What's the best way to run an oracle stored procedure from a sql server
> stored procedure or DTS job?
>
> An example would be great!
>
> Thanks in advance,
> Mark
>
>

Relevant Pages

  • Oracle cursor problem using DAAB Stored Procedure
    ... When I try to ExecuteDataset method with a stored procedure that returns a ... So I tried to call the oracle stored procedure using different parameters ... Create or Replace PACKAGE BODY APP ...
    (microsoft.public.dotnet.framework)
  • RE: master..xp_cmdshell Error 997 from GetProxyAccount
    ... Start SQL Enterprise manager ... right mouse on SQL Server Agent and select properties ... select Job System tab ... > This all works when the stored procedure is fired inserting the record ...
    (microsoft.public.sqlserver.programming)
  • RE: master..xp_cmdshell Error 997 from GetProxyAccount
    ... Start SQL Enterprise manager ... right mouse on SQL Server Agent and select properties ... select Job System tab ... > This all works when the stored procedure is fired inserting the record ...
    (microsoft.public.sqlserver.security)
  • ERROR [HY105] [ODBC driver for Oracle] Invalid parameter type
    ... Need help getting back a resultset from an oracle stored procedure ... type varchar and I'm getting an error on the calling side reading: ... DataSet objDS = new DataSet; ...
    (microsoft.public.data.odbc)
  • Re: User-Defined Function
    ... It doesn't even have to be this elaborate with a linked server. ... Declare @line varchar ... suitable extended stored procedure. ... > server setup and an example of how to get directory information (but not ...
    (microsoft.public.sqlserver.programming)