Post reply

Execute Oracle Stored Procedure in SQL Procedure

  • June 22, 2006 at 1:24 pm

    #115562

    Hi there,

    I am trying to run Oracle Stored Procedures in an SQL Procedure and i get this error:

    SELECT * FROM OPENQUERY

    (PINGUIM2 , 'CALL B2B.ALTERA_TIRAGEM('EGM20060001','9724731332','1995','123',{resultset 1, P_OUT_TABLE})')

    the OLE DB provider 'MSDAORA' indicates that the object has no columns.

     

  • June 26, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • June 26, 2006 at 4:59 pm

    #645947

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_9ooj.asp

    - from BOL v8.

    It may not be relevant, but interestingly in BOL v9 the following is inserted just before the final paragraph:

    OPENROWSET and OPENQUERY support pass-through queries in which the query string contains a stored procedure call only when the query has one of the following characteristics:

    • Executes a single, static SELECT statement.

    • Does not use any dynamic EXECUTE statements.

    • Does not perform any data modification operations.

    There is no indication that this is a new 'feature' introduced in SQL9. It's more likely a long-standing restriction, perhaps arising from the need to support distributed transactions.

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply