dbTalk Databases Forums  

Re: pb with CIS object of RPC type

Go Back dbTalk Databases Forums Databases sybase.public.omni Re: pb with CIS object of RPC type

sybase.public.omni sybase.public.omni


Discuss Re: pb with CIS object of RPC type in the sybase.public.omni forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sau-boon Lim
 
Posts: n/a

Default Re: pb with CIS object of RPC type - 12-10-2003 , 09:11 PM





Hi,

Can you show more details on the results you get from the RPC, the first and
subsequent times?

Also, which version of ASE are you using?

Regards,
Sau-Boon
<lionelM> wrote

Quote:
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
option

best regards
Lionel M.



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top