Skip to content

Instantly share code, notes, and snippets.

View hamermike's full-sized avatar

Mike Hamer hamermike

View GitHub Profile
@hamermike
hamermike / tdt_1.0.1.14_code_analysis_example.ps1
Last active March 4, 2018 21:36
Toad DevOps Toolkit PL/SQL Code Analysis
# Start Toad DevOps Toolkit
$TDT = New-Object -ComObject 'Toad.ToadAutoObject'
try {
# Set Code Analysis parameters
$TDT.CodeAnalysis.Connection = $TDT.Connections.NewConnection('user/pwd@db')
$TDT.CodeAnalysis.ReportName = "CA Report"
$TDT.CodeAnalysis.OutputFolder = "C:\Output"
$TDT.CodeAnalysis.ReportFormats.IncludeHTML = $TRUE
# Set database objects to Analyze
@hamermike
hamermike / tdt_1.0.1.14_code_analysis_example.py
Last active March 4, 2018 19:31
Toad DevOps Toolkit PL/SQL Code Analysis
# Import win32com.client so that we have easy access to COM interfaces.
import win32com.client
# Connection information used to connect to your Oracle database.
source_connection = "SCOTT/SCOTT_PASSWORD@ORA_DATABASE"
# Start Toad DevOps Toolkit.
tdt = win32com.client.Dispatch("Toad.ToadAutoObject")
# Create and assign a Toad DevOps Toolkit connection.