Re: Error -710 from stored procedure

Hi Usually this problem can be fixed by running an "update statistics for procedure my_procedure". Anyway, It's the same to run on weekly or monthly basis "update statistics" for the database Later Omar Muqoz ----- Original Message ----- From: "Heinz Weitkamp" <heinz.weitkamp@westfleisch.de> To: "user-group Informix (E-Mail)" <informix-list@iiug.org> Sent: Wednesday, September 21, 2005 9:12 AM Subject: 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 sending to informix-list