Hi,
I posted about this error last week, but have got a lot further in
locating the problem. However I have not come up with a fix.
I call a stored procedure when creating a user.

If two users are created at the same time the first will work and the
second will get no results form the stored proc call.

If the users are created 15 mins apart with the same params they are
both created correctly.

From the remote loader log with logging at 25 the difference shows as:
when the procedure is instantiated it works, if called while still in
cache or whatever it does then the proc fails.

I have tried modifying the procedure with "create procedure......with
recompile" and this has not worked.

Anyone got any ideas on this? is this a driver problem? Any way to get
the proc to not cache??

All help appreciated, thanks.


--
parrydave
------------------------------------------------------------------------
parrydave's Profile: http://forums.novell.com/member.php?userid=6588
View this thread: http://forums.novell.com/showthread.php?t=403955