I am new to Code Tester and I am trying to test if a procedure inserts a row correctly. My idea was to insert a row into the local table with the expected value, hence it fails. I guess the problem is, that this table has an ID field as primary key, which value increases dynamically with a trigger + sequence, so I cannot know which value is inserted into this field. If I leave this field blank, he says I cannot empty NULL into ID.
How can I resolve this issue and check if the correct values are inserted?
Thanks in advance,