Invalid procedures.

Posted in 1999

David Casas Rosado — Wed, 30 Jun 1999 21:44:11 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi all. I'm running informix 7.22 on NT4.0 Some or our developers create new procedures on their users and this procedures becomes to invalid status. (It appears some bad entries on the procedure) I.e:=20 =09 Ny4yMkMxAAAAAAIAASDGgw8oxoMPCMaDDxDGgw9fBQZZXwUBAAABbTR0X3BhdHJvbmVzAAAB= aW5m b3ZtZAAAAUNPQ08AAAFtYzI1AAAB2MWDD.DFgw_AxYMPyMWDD18adfaefadb4eaaAAAARfcG= F0cm 9uQxMAAAFpbmZvdm1kAAABQ09DTwAAAW1jMjUA=C5f=0F=15 Ny4yMkMxAAAEAAAAAgABAABQAIAAAAAAAAAAadfafAAAAAAAAAAAARsAAPPP3b2VhdGUgdml= ldyA iaW5mb3ZtZCIubTRfcGF0cm9uZXMgKGlkX3BhdHJvbixuX3BhdHJvbixsb25naXR1ZCxpZF9= 0aXB vX3BhdHJvbixpZF9yklwnfkdLGZlY191bHRfYWN0dWFsaXphYyxjb21adfafafafFFFFFFC5= pZF9 wYXRyb2 create procedure....... =09 By the moment, the solution is drop this invalid procedures and re-create again. Anybody knows how can i know what procedures are invalids? I know that on Oracle i can run a query to the user where the status procedure's are INVALID. it this possible on Informix? Also, anybody knows why this procedures becomes to invalid status? Thanks for your help on advance.

↪ replying to David Casas Rosado

Art S. Kagel — Thu, 01 Jul 1999 10:22:40 -0400 — source: Informix-list mailing list archive (1991-1998)

David Casas Rosado wrote: > > Hi all. > > I'm running informix 7.22 on NT4.0 > Some or our developers create new procedures on their users > and this procedures becomes to invalid status. > (It appears some bad entries on the procedure) > > I.e: > create procedure....... > > By the moment, the solution is drop this invalid procedures > and re-create again. > > Anybody knows how can i know what procedures are invalids? > I know that on Oracle i can run a query to the user where > the status procedure's are INVALID. > it this possible on Informix? > > Also, anybody knows why this procedures becomes to invalid > status? What is the error message/code you are seeing. You may just have to reoptimize the procedure. This can happen if you alter the table or its fragmentation or if you run UPDATE STATISTICS on the table. You can fix these problems by running UPDATE STATISTICS FOR PROCEDURE procname; which will cause the optimizer to develop a new query plan for the procedure. You should do this as part of you UPDATE STATISTICS scripts. Art S. Kagel