The index lost in or out parameters-CodePudding

 
Create the trigger input_excel_trigger_insert after insert on input_excel for each row 
The begin 
Insert into test_once_log (id, create_time, table_set, is_delete, main_key_0) values (the lower (sys_guid ()), sysdate, '202101214022044308', 'false' : new, id); 
end;

The result error: index lost in or out parameters: : 1

If you remove the insert statement can create
To: new id for 'ABC' single insert statement, is can
The question is: what can use the new, some people met yet?

CodePudding user response:

Post, test_once_log table structure is suspected you is_delete data type is not a character,