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.
The Stored procedure "siic" hasn't been dropped for somes months. What
occurs?
I using INFORMIX-OnLine Version 7.14.UC1 on HP-UX.
Did you explicitely "update statistics for procedure siic"
or just an ordinary "update statistics" for the whole
database ?
If not, try the first one.
Hth,
Chris
> 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.
> The Stored procedure "siic" hasn't been dropped for somes months. What
> occurs?
> I using INFORMIX-OnLine Version 7.14.UC1 on HP-UX.