Re: Error: 1048 Column cannot be null for Insert in Stored Procedure

[Peter Brawley]

Your param names are the same as the column names for which they carry input, so MySQL cannot distinguish the param name from the column name.

Always give params names that can't conflict with column names referenced in the sproc. A simple way to do this is to adopt a convention, eg all param references to columns are p_colname.