Good Afternoon Everyone,
I am trying to create a Toad Automation Script for a process my team does. If I had a Toad Professional License, I could do it pretty easily through Cross Database SQL, but because I do not, and it doesn't appear I will any time soon, I was hoping I could do something like this:
- Create a Variable for Report 1 (ran from Oracle), where the analyst can enter in a month and year to run the report.
- Run Report 1, with the parameter defined in the variable above.
- Use the results from Report 1, to then connect to another Database (Teradata) to run report 2.
- Use the results from Report 2, to then connect back to Oracle, and run report 3.
So far, steps 1 and 2 are working. I have taken the results from Report 1, exported them to an Excel file, the connected Toad to the Excel file (as apparently, I cannot connect to local storage). From that Excel file, I wrote a simple query (something like --- Select Distinct "Unique" from Sheet1), since I need the Unique item to then run the Teradata query. I then named the variable "UNI"
I cannot figure out how to then, take those results, and bring them back into the teradata query. I have already updated the query to look for :UNI, but it won't run. I keep getting this error:
[Teradata Database]  Precision error in FLOAT type constant or during implicit conversions.
I understand this error to be something with the data types? However, I have tried casting, and converting to make the data types match.
Lastly, I have taken the results from Query 1, and used them to run query 2, and that works, so I am just trying to do it through Toad Automation. Any help would be greatly appreciated.