how to test insert using procedure

  • Libor Nenadál
    Libor Nenadál

    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.


      insert_cust("John", "Brown");

    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.