Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    7

    Question Unanswered: Call Oracle procedure using T-SQL (e.g. from sql server stored procedure)

    I am writing a Sql Server stored procedure that performs several operations against an Oracle database. Some of these operations could be aggregated into a single Oracle stored procedure, which I have created.

    My question is, how can I call the Oracle stored procedure from my Sql Server stored procedure? I have a linked server up and working, but the execute syntax I have tried just doesn't work. I have also tried using the "CALL" command, with no success.

    Has anyone done this without resorting to an extended stored procedure? Examples are appreciated!

  2. #2
    Join Date
    Mar 2002
    Posts
    7
    In answer to my own question, in books online I found the following statement under the topic "External Data and Transact-SQL":

    "Stored procedures are supported only against SQL Server data sources."

    Ah well, at least I was able to get functions w/input parameters to work...

  3. #3
    Join Date
    Aug 2001
    Posts
    24

    Executing Oracle SP thru SQL Server Linked Server

    Hey...I also have the same issue to be resolved.
    Let me know if u are able to solve that...

    Cheers !!!
    ~ HK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •