Re: sysprocplan

In article <34F2F0AE.2780@dati.lv>, Leonids.Voroncovs@dati.lv writes >Hi, all! Help needed. >Two users executes statement SELECT my_field, my_proc( my_param ) FROM >... and one of them geted error - "Cannot read system catalog ( >sysprocplan )". What happens and how I can escape this situation? I must >say that this situation is not stable. >May be INFORMIX in some cases updates this table and don't commits >operation? >Best wishes. Leonid. If Informix you execute a stored procedure which relies on tables/views etc which have change structure then Online reoptimizes then stored procedured. It then it updates and hence locks rows in sysprocplan. If you are in a transaction these locks are held. A bug fix was done in Online 5.03 because a stored procedure which accessed temporary tables would ALWAYS be reoptimized EVERY time it was executed. This no longer happens. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care