Can you show more details on the results you get from the RPC, the first and
Also, which version of ASE are you using?
We have created a stored procedure, that contains a |
reference to a CIS object (associated to distant RPC).
The 1st time we execute the stored procedure, the result is
correct. But the second time & the other times, the result
is bad, because CIS object returns a bad result.
To resolv the pb, we have to sp_recompile th stored
procedure each time before executing it.
Thanks to help me to understand and to avoid sp_recompile