Skip to content

Parameter with PK is not used to insert #5

@jgebal

Description

@jgebal

The generated code contains a bug:

  FUNCTION create_row( p_EMPLOYEE_ID IN EMPLOYEES_TEST."EMPLOYEE_ID"%TYPE DEFAULT NULL, p_COMMISSION_PCT IN EMPLOYEES_TEST."COMMISSION_PCT"%TYPE, p_SALARY IN EMPLOYEES_TEST."SALARY"%TYPE ) 
  RETURN EMPLOYEES_TEST."EMPLOYEE_ID"%TYPE IS
    v_pk EMPLOYEES_TEST."EMPLOYEE_ID"%TYPE;
  BEGIN
    INSERT INTO EMPLOYEES_TEST ( "EMPLOYEE_ID", "COMMISSION_PCT", "SALARY" )
      VALUES ( v_pk, p_COMMISSION_PCT, p_SALARY )
      RETURN "EMPLOYEE_ID" INTO v_pk; 
    RETURN v_pk;
  END create_row;

Parameter p_EMPLOYEE_ID is not used to insert.

Used generation parameters:

  /** 
   * This is the API for the table EMPLOYEES_TEST. 
   *
   * GENERATION OPTIONS 
   * - must be in the lines 5-25 to be reusable by the generator
   * - DO NOT TOUCH THIS until you know what you do - read the
   *   docs under github.com/OraMUC/table-api-generator ;-)
   * <options 
   *   generator="OM_TAPIGEN"
   *   generator_version="0.4.0"
   *   generator_action="GET_CODE"
   *   generated_at="2017-05-27 03:55:53"
   *   generated_by="..."
   *   p_table_name="EMPLOYEES_TEST"
   *   p_reuse_existing_api_params="TRUE"
   *   p_col_prefix_in_method_names="TRUE"
   *   p_enable_insertion_of_rows="TRUE"
   *   p_enable_update_of_rows="TRUE"
   *   p_enable_deletion_of_rows="FALSE"
   *   p_enable_generic_change_log="FALSE"
   *   p_enable_dml_view="FALSE"
   *   p_sequence_name=""/>

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions