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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.