-
Notifications
You must be signed in to change notification settings - Fork 16
Parameter with PK is not used to insert #5
Copy link
Copy link
Closed
Labels
Description
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=""/>
Reactions are currently unavailable