Now I’ve got 3.1.5 I’d like to add some more automation.
Currently using Oracle 9, will shortly be using Oracle 10 in parallel.
I need to generate separate files for various parts of the DDL, eg tables, views, functions, etc.
I can create OTPs for each file and manually generate but I’d like to add a button to the form that loaded and generated each of a number of specified OTP selections in turn.
It would also need to manipulate the file name and add additional items to the script such as SPOOL command at the start.
I had achieved something like this in the earlier commercial version (but I had to edit TDM system scripts).
Can you give me some idea on how to do;
- loading of OTP selection from code
- creating a script in a user package that will be run from the form button