how to test a modifying procedure?

PL/SQL question
I created a procedure to modify a small table (two columns). When testing the procedure, what is the best way to verify if a record being modified exists in the table or not? Use an IF, THEN statement, a function, or a trigger?

I would appreciate an example of the syntax used. Received on Mon Dec 10 2001 - 09:28:57 CST