how to test insert using procedure

2008-02-18
2013-04-25
  • Libor Nenadál
    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.