I am using TOAD Data Point 188.8.131.526 connecting to an Oracle Database. I have a rather intense number of stored procedures to run and at various points these will require human intervention. Specifically I want to kick off the import of FOUR files (two from state ‘a’ and two from state ‘b’). Sometimes all are processed at the same time - but other times only one state would be processed at a time. There is no ‘front end’ to manage the process.
I’d like to have toad automation (if section) ask the user which states would they want to process now:
declare and initialize a variable to zero (numeric)
Do you wish to import TEXAS information?
If YES - run script - when complete ask user if they desire to import ARKANSAS information. (and sets a variable that was initialized to zero - to ONE.)
if NO - ask user if they desire to import ARKANSAS information.
If YES - run import script and then (and sets a variable that was initialized to zero - to ONE.)
If NO - move forward
If the Variable is ZERO then the script ends (that means the user desires to import no data.
If the variable is ONE then the script will launch a long stream of oracle stored procedures.
Please let me know if this is possible - and if so - how the heck to do it!
I’m a rather experienced SQL and VB programmer. I have the import templates and stored procedures completed that are required for this.