Error -710 from stored procedure

Hi all, IDS 7.31 UD4 SCO Unix 3.2 5.0.6 Sometimes when we execute a stored procedure it fails with the error: -710, Table (informix.systables) has been dropped,altered or renamed. The stored procedure makes a SELECT ur_benkrz_to_bennr(imandant,iben) INTO ben FROM systables WHERE tabid=1; The stored procedure ur_benkrz_to_bennr only makes an SELECT INTO. No modifications on any table. At execution time of the stored procedure Systables was not dropped,altered or renamed. I altered an other table (drop (primary) key, create (primary) key) in the database, but such an action don't alter the systables (i am right?). What can be the issue of such an error? Any workaround? Thanks in advance for any answer. (excuse my poor school-english) Heinz sending to informix-list

The problem probably relates the system table somehow being altered after the stored procedure was created and the query plan becoming out of date. I would suggest you create a dummy table which has one row in it and use the dummy table rather than the system table when you run the query. See if the error still occurs but with your dummy table instead of the system table. Heinz Weitkamp wrote: > Hi all, > > IDS 7.31 UD4 > SCO Unix 3.2 5.0.6 > > Sometimes when we execute a stored procedure it fails with the error: > > -710, Table (informix.systables) has been dropped,altered or renamed. > The stored procedure makes a > SELECT ur_benkrz_to_bennr(imandant,iben) INTO ben > FROM systables WHERE tabid=1; > > The stored procedure ur_benkrz_to_bennr only makes an SELECT INTO. No > modifications on any table. > > At execution time of the stored procedure Systables was not dropped,altered > or renamed. > I altered an other table (drop (primary) key, create (primary) key) in the > database, but such an action don't alter the > systables (i am right?). > > What can be the issue of such an error? > > Any workaround? > > Thanks in advance for any answer. > (excuse my poor school-english) > > Heinz > sending to informix-list