we have temporarly changed your package qu_generate where you generate procedure call for testing procedure.
pl ('if qct.enabled then ');--added by marko
Call the program inside a loop that uses the values in the collections
pl ('populate_collections (l_min_count);');
pl ('FOR l_index IN 1 .. l_min_count LOOP');
pl (' call_the_program (l_index);');
pl ('END LOOP;');
pl ('end if;');--added by marko
I use my function qct.enabled where I programmatically enable or disable specific test case. Why I do that is, I would like that for some specific procedure mypack.myproc to have executed all 7 test cases on one data base, but on the other only 6 out of 7, so one is not executed. Why this one is not executed is because some parameters in my program are not set. This case on that specific data base should never run, and when ran it would raise an exception. So why not set all the parameters. Enabling this parameter will influence in results of my others program and some parameters are exlusing each others.
You can imagine that data base is one of our customer (bank).
Unfortunatly we have a lot of customized programs which in general work the same, but on the other hand they do have some exceptions. They are controled with setting the parameter in some table.
This is not the answer, it is hard coded. How can I enable test case per data base or per some global parameter.
Hmmm. That sounds confusing. Let’s try it this way: if you havemultiple versions of >the same package being tested, and schema A haspkg.proc2, but schema B does >not have proc2 in pkg, then the test codewill not compile.
This is obvious.