Libor Nenadál - 2008-02-18

Hi,
I'm stuck at a quite simple testing scenario. I have a procedural wrapper for table insert. And I want to test it inserts row into the specified table.

Example:

BEGIN
  insert_cust("John", "Brown");
END;
/

and than want to issue:
select name, surname from customers;

and make sure it contains row with John Brown.

As the procedure does not return any value I can not use test tag. I thought I could use diff tag and issue the procedure call in prepare phase but it is not allowed. :-/ So should I create one test where I call the procedure and than second test where I issue select statement and compare it to the result set (the actual test)? It is a bit clumsy, don't you think?

Thanks in advance for any clue.