Error 721 Stored procedure is no longer valid

I have got INFORMIX-OnLine Version 7.14.UC1 on HP-UX. My database server has two databases A and B. I have a stored procedure in A: create procedure art_var_k(...) ---> do a select of a view of databaseA ---> The view uses a stored procedure of database A. If I call the stored procedure from A: execute procedure art_var_k(...)this works well. If I call the stored procedure from B: execute procedure A:art_var_k(...)the system gives me this error: 721 Stored procedure is no longer valid I don't know what occurs. I've updated statistics for the first stored procedure, the view and the second stored procedure in many orders possible and I've dropped and recreated the stored procedures an the view. Please help. Thanks in advance. Miguel Angel Ferrer ma-ferrer.eos@ctv.es EOS Inform'tica S.A.L.

"Miguel Ángel Ferrer (EOS Informática S.A.L.)" wrote: > > I have got INFORMIX-OnLine Version 7.14.UC1 on HP-UX. > My database server has two databases A and B. > I have a stored procedure in A: > create procedure art_var_k(...) ---> do a select of a view of database> A ---> The view uses a stored procedure of database A. > > If I call the stored procedure from A: > execute procedure art_var_k(...)> this works well. > > If I call the stored procedure from B: > execute procedure A:art_var_k(...)> the system gives me this error: > 721 Stored procedure is no longer valid > > I don't know what occurs. > I've updated statistics for the first stored procedure, the view and the > second stored procedure in many orders possible and I've dropped and > recreated the stored procedures an the view. Does the stored procedure in database A reference tables without qualifying the database to which it refers? Is it possible that a same named table exists in database B which is confusing the optimizer? Try modifying the procedure to use a qualified table name (ie - database:tablename) and see what happens. Art S. Kagel

I've used qualified name for all tables and stored procedure in art_var_k and the view and Informix gives me the same error. Error 721 Stored procedure is no longer valid Thanks for your help, I'm still trying to solve my problem. Art S. Kagel <kagel@bloomberg.net> escribi' en el mensaje de noticias 380F4297.FADC3C1A@bloomberg.net... > "Miguel 'ngel Ferrer (EOS Inform'tica S.A.L.)" wrote: > > > > I have got INFORMIX-OnLine Version 7.14.UC1 on HP-UX. > > My database server has two databases A and B. > > I have a stored procedure in A: > > create procedure art_var_k(...) ---> do a select of a view of database> > A ---> The view uses a stored procedure of database A. > > > > If I call the stored procedure from A: > > execute procedure art_var_k(...)> > this works well. > > > > If I call the stored procedure from B: > > execute procedure A:art_var_k(...)> > the system gives me this error: > > 721 Stored procedure is no longer valid > > > > I don't know what occurs. > > I've updated statistics for the first stored procedure, the view and the > > second stored procedure in many orders possible and I've dropped and > > recreated the stored procedures an the view. > > Does the stored procedure in database A reference tables without > qualifying the database to which it refers? Is it possible that a same > named table exists in database B which is confusing the optimizer? Try > modifying the procedure to use a qualified table name (ie - > database:tablename) and see what happens. > > Art S. Kagel