Urgent : Error (-312) : Cannot update system catalog (sysprocplan).

Posted in 2003

LUQUE Valdivia Omar - DBA Marina — Thu, 22 May 2003 11:51:17 -0500 — source: Usenet: comp.databases.informix

Hello everybody, I have a problem about a stored procedure... Error (-312) : Cannot update system catalog (sysprocplan). here is my SP : =============== CREATE PROCEDURE "dbasis".spplanilla_actlugar(p_codcia char(3), p_fchini char(10), p_fchfin char(10), p_valor char(1)) RETURNING varchar(20); UPDATE hc_vales set flglugproce = p_valor where hc_vales.codcia = p_codcia and hc_vales.fchvale >= p_fchini and hc_vales.fchvale <= p_fchfin and flglugproce is null or flglugproce = "";RETURN 'OK'; END PROCEDURE A end user, execute the SP : ============================ EXECUTE PROCEDURE SpPlanilla_Actlugar('001','01/04/2003','30/04/2003','0') and then a get the following error : ==================================== Cannot update system catalog (sysprocplan). */ I have a lot space in my Disk, i don't understand what's happening... Please help me, What's the problem ???? Thanks for advanved Omar.