Subject -804 Error ( randomly )
Author Aldo Caruso
Hi,

I'm inserting records from PHP / Apache / Ubuntu in a Firebird
table. This table has an integer non null field, and a before insert
trigger which takes care of setting it to the next integer value in case
the user attempts to set this field to null.

If this field is set to any integer from PHP there is no problem.

On the other hand, if it is set to null ( lefting to the trigger
the task of assigning it ) any of the following behaviours happens
(randomly)

1) A -804 error is shown in the apache log, with the message: "Dynamic
SQL Error SQL error code = -804 Incorrect values within SQLDA structure"

2) The Apache sub process is aborted, with the log message: "child pid
NNNN exit signal Segmentation fault (11)"

3) A random integer is assigned to the field. This behaviour is by far
less frequent, but happened a couple of times.

Thanks in advance for any help.

Aldo Caruso