Home -> Usenet -> comp.databases.oracle -> Prob with Pro*C and signal hand. func.

	I have been having problems updated a table in a pro*c app. I have 
	a signal handling function to catch a child processes termination
	(sigchld). First in the function i call wait to return the pid of
	the child, then call the signal(SIGCHLD,myfunc) again to turn the 
	handler back on, and then try to update a table in oracle from
	the signal handling function.  I theory this should work fine, but
	I get a ora-3106 error about 25% of the time.  After talking to
	oracle they said that pro*c,sql and oracle does not support such an
	idea, that is to call a embedded statement from the signal handling
	function.  Anybody have any ideas? Some more info on the problem,
	this is a async process, monitoring a table for changes, then spawning
	new process when a flag is set.  When the child dies I need to
	update the status of that record with a timestamp and other info.

	As always, thanks in advance for any insight!