Stored Procedures Help!!!

Hi All My Stored Procedure gets some information from a teble and return it to a client.When 3 clients run Stored rocedure in the same time we get following errors : (Error -107) ISAM error: record is locked (Error -243)Could not position with a table ( table_ name) Is that possible somehow to catch these errors and to return to a client some normal message ? Thanks Igor

Try looking up 'ON EXCEPTION' in the manuals. I don't know exactly what you want the clients to do on an exception, so I can't be much more specific than that. In article <39412bb9.95455456@news.ca.geac.com>, i.sokolsky@geac.com (Igor) wrote: > Hi All > > My Stored Procedure gets some information from a teble and return it > to a client.When 3 clients run Stored rocedure in the same time we get > following errors : > (Error -107) ISAM error: record is locked > (Error -243)Could not position with a table ( table_ name) > > Is that possible somehow to catch these errors and to return to a > client some normal message ? > > Thanks > > Igor > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.