We have successfully implemented an autonumber for a form but are experiencing difficulty inserting the record into the database. On this page we insert a new contact person, but we run into the following error and no data posted to our database:
"ORA-06550: line 2, column 16:PL/SQL: ORA-00947: not enough values
ORA-06550: line 2, column 4: PL/SQL: SQL Statement ignored"
The "not enough values" part makes me think there's a problem with passing the parameter, but I'm not sure where or how. I've checked the ordering in the SQL statement and it appears fine. I'm guessing the problem is somewhere on the XML side. Has anyone else experienced something similar to this? What steps did you have to take in order for your parameters to pass through properly as queries?