CREATE OR REPLACE PACKAGE Q##939979339_qtp
FUNCTION table_function ( data_in IN SYS_REFCURSOR ) RETURN Q##939979339_qnt;
PROCEDURE get_data (
variable_name_in in VARCHAR2
, collection_inout IN OUT Q##939979339_qnt
I am struggling with this tool. I have written a test that tests the returning of a recordset (ref cursor).
Although I have got this test to work I struggle to make any changes to the test without the test-compilation failing. I then remove the single line of code and re-compile and it still fails.
I am also unclear as to when the test code is re-generated. There are also a number of objects on my target test schema that are created.
I think these objects are there to support this ref_cursor testing. I have now deleted the entire test but these packages (there are 21 of them) persist. I also get a number of errors complaining that the referenced generate packages do not exist.
I understand that generated code should not be modified , the code should be added/tweaked and the application should then generate this code into the overall test packages. Great in theory but I question whether the re-generation is working correctly.
Sorry for the dis-jointed comments. I am concerned that this tool is not mature enough for use yet. I am using version 184.108.40.206. I have been struggling with this for 2 days now and seem to be making no progress.
I guess my biggest problem is working out when the code is auto - generated and removal of tests should result in database packages being removed (i would
imagine). Is there any in-depth documentation I can reference.
Here is an example (see below).
OR REPLACE PACKAGE Q##939979339_qtp##939979339_qnt;##939979339_qnt;PLS_INTEGER;PLS_INTEGER;*–PROCEDURE initialize;–FUNCTION table_function ( data_in IN SYS_REFCURSOR ) RETURN Q##939979339_qnt;–*PROCEDURE get_data (in VARCHAR2, data_in IN SYS_REFCURSOR, collection_inout IN OUT Q##939979339_qnt, count_out OUT PLS_INTEGER); Q##939979339_qtp;