Skip to content

Instantly share code, notes, and snippets.

Mike Hamer hamermike

Block or report user

Report or block hamermike

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@hamermike
hamermike / tdt_1.0.1.14_code_analysis_example.ps1
Last active Mar 4, 2018
Toad DevOps Toolkit PL/SQL Code Analysis
View tdt_1.0.1.14_code_analysis_example.ps1
# 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 Mar 4, 2018
Toad DevOps Toolkit PL/SQL Code Analysis
View tdt_1.0.1.14_code_analysis_example.py
# 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.
You can’t perform that action at this time.