Re: Recursive Stored Procedures

> > > Folks, > > I was putting together a recursive stored procedure - things were going just > fine - then I popped a second window and used it again - while the > first one was still running. The engine crashed and I had to go through a > tbinit/restore to get it back. Anyone else ever see this? > (Online5.0, isql/4gl 4.10). > > cheers > j. I've not come across that one myself but, there is a bug in the HP version of 5.0, that is fixed in 5.01. A process calling a SP will take and hold a lock on the stored procedure making it inaccessable to any other process and causing the second process to fail on executing the SP, but this didn't bring the engine down. You may be seeing an extreme version of this problem due to using the SP recursively. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 375-5222 (Work) Address: 700 Airport Blvd. #300 (415) 775-7762 (Home) Burlingame, CA 94010-1937 Fax: (415) 375-5019 ----------------------------------------------------------------------