Re: Problem with SYSPROCPLAN

Posted in 1998

Topics: Stored Procedures & SPL, Error Codes & Troubleshooting

David Thompson — Wed, 03 Jun 1998 12:46:40 +0100 — source: Informix-list mailing list archive (1991-1998)

Jerry Hamilton wrote: > Help! > > I have an application developer who has just written a stored procedure > that is 17 printed pages long. It's major big. Everything it is executed > I get the following message: > > SQL ERROR (-312) Cannot update system catalog (sysprocplan), [ISAMerror > -134:ISAM error: no more locks] > > I'm confused about the locks. Is Informix complaining about the locks on > the user tables or the locks in sysprocplan. > > Thanks The problem is with sysprocplan. Does the routine use a "begin work "and then create some temp tables ? If it does then I think this will cause the problem you are getting. Try "set lock mode to wait 2" ( 2 is the number of seconds to wait before the lock is released, you can determine how long to wait) before you run the routine. David -- David Thompson (+44171 721 6808) Salomon Smith Barney (London) Email : mailto:david.thompson@ssmb.com Internet : http://www.smithbarney.com

Glossary

ISAM error