I am using 2000, and have created a linked server connection from sql server to oracle 10g2 and can execute stored procedures using the OPENQUERY method, and get results back.
However, I want to execute a stored procedure which returns no records. Having searched via google (and within Tek Tips) I have found two articles which say that to simply execute a stored procedure is impossible. One work around is to return a dummy value (or values) and the other is to insert a record into a dummy table in oracle, and then rely on an Oracle "AFTER INSERT" trigger to invoke the stored procedure.
Books online goes nowhere near this level of detail, so I can't easily tell if this is correct.
Can someone provide me with a reference to authoritative documentation which can state beyond all doubt whether or not what I am trying to achieve is possible?
If it is impossible, can anyone advise to what version of sql server I would have to upgrade, so that it does become possible?
Regards
T
However, I want to execute a stored procedure which returns no records. Having searched via google (and within Tek Tips) I have found two articles which say that to simply execute a stored procedure is impossible. One work around is to return a dummy value (or values) and the other is to insert a record into a dummy table in oracle, and then rely on an Oracle "AFTER INSERT" trigger to invoke the stored procedure.
Books online goes nowhere near this level of detail, so I can't easily tell if this is correct.
Can someone provide me with a reference to authoritative documentation which can state beyond all doubt whether or not what I am trying to achieve is possible?
If it is impossible, can anyone advise to what version of sql server I would have to upgrade, so that it does become possible?
Regards
T