title: Cannot insert the value NULL into column '', table column does not allow nulls. INSERT fails.Failed to execute following SQL block
body: <p>I am getting following error when i execute following command. Can someone please help! </p>
  
  <blockquote>
    <p>Cannot insert the value NULL into column '', table column does not allow nulls. INSERT fails.Failed to execute following SQL block   </p>
  </blockquote>
  
  <pre><code>BEGIN
      Select @v_setting_val=setting_val from EGPL_PROGRAM where setting_id=@v_setting_id
      and group_id =
          (select group_id
          from egpl_pref_group
          where group_type = 'departmental'
          and department_id=@v_department_id)
  
      INSERT INTO EGPL_PROGRAM
      (GROUP_ID, SETTING_ID, SETTING_VAL, IS_PREFERENCE, MODIFIER_ID, MODIFIED_DATE)
      VALUES
      (@v_group_id, @v_setting_id, @v_setting_val,'n',1,getdate());
  
      PRINT('Inserted the following value for group ' + convert(nvarchar, @v_group_id ))
      PRINT('Setting_id : ' + convert(nvarchar, @v_setting_id) + ' setting_val : ' + @v_setting_val)
  END
  </code></pre>