Database Task Version Controlling

We cannot use export option in the client to version control it as xml file, it's only possible to import in different environment directly. 

If still do you need to version control DB task as .ins file. you can generate .ins file like below. 

Step 1: Execute below using your DB Task ID 

declare 

ins_data_ VARCHAR2(32000); 

schedule_method_id_ NUMBER := 90; 

begin 

   Batch_Schedule_Method_API.Export__(ins_data_, schedule_method_id_); 

dbms_output.put_line(ins_data_); 

end; 

 

Step 2: It will generate the content we need and you can save it as .ins file




Step 3: The ins file should be placed in the 'source/[component]/database' folder. 

Post a Comment

0 Comments