Error 721 Stored procedure is no longer valid
Please help.
I have got a stored procedure called "siic":
create procedure siic(v1 char(16),v2 char(16),igual char(32),dist char(32))
returning char(32);if v1=v2 then
if igual is null then
return " ";
else
return igual;
end if;
else
if dist is null then
return " ";
else
return dist;
end if;
end if
end procedure;
I have got a view that uses this stored procedure:
create view art_var (articulo,descri,cf,cu,tipo,var) as
select x0.articulo ,x0.descri ,x0.valor ,x0.cu ,x1.tipo ,TRIM
( BOTH ' ' FROM siic(x1.lis_par [1,2] ,x1.lis_para [1,2]
,x2.valor ,x3.valor_r )) || TRIM ( BOTH ' ' FROM siic(x1.lis_par
[3,4] ,x1.lis_para [3,4] ,x4.valor ,x5.valor_r )) from articulos
x0 ,struc_var x1 ,outer(art_valor x2 ,outer(implica
x3 ) ) ,outer(art_valor x4 ,outer(implica x5 ) ) where
(((((((((((x0.valor = x1.cf ) AND (x2.articulo = x0.articulo
) ) AND (x2.param = x1.lis_para [1,2] ) ) AND (x3.param =
x2.param ) ) AND (x3.valor = x2.valor ) ) AND (x3.grupo =
'B' ) ) AND (x4.articulo = x0.articulo ) ) AND (x4.param =
x1.lis_para [3,4] ) ) AND (x5.param = x4.param ) ) AND (x5.valor
= x4.valor ) ) AND (x5.grupo = 'B' ) ) ;
This has work well until this week, when I execute and stored procedure that
access to the view the system gives me this error:
721: Stored procedure (siic) is no longer valid.I have updated statistics of all and Informix still gives the 721 error.
I've executed this:
"update statistics for procedure siic"
"update statistics high for table art_var"
The Stored procedure "siic" hasn't been dropped for somes months.
What occurs?
I using INFORMIX-OnLine Version 7.14.UC1 on HP-UX.