Blogs | Toad

Toad for Oracle – How can I pass parameters to an external application?

Post author:Written By |
Toad for Oracle – How can I pass parameters to an external application?

This example shows how to load a script into SQL*Plus for the current session and execute it:

  1. Go into PM Options → Associations
  2. Remove SQL as an extension for SQL Editor (or anywhere else it may be)
  3. Click Add
    • Title: SQL Plus
    • Program: C:\oracle\ora92\bin\sqlplusw.exe
    • Working Dir: C:\oracle\ora92\bin
    • Parameters: $UID/$UPW@$SID @$FIL
    • Extension: SQL
  4. Click OK. The first Parameter block indicates a connect string for current TOAD session. The $FIL macro does a substitution for the underlying file. The @ is required by SQL*Plus to indicate script execution.
  5. Now add a Folder Item & browse to find a sample SQL script to execute. It will be added, and take on the SQL*Plus Icon.
  6. You can now double-click the item or right-click Load, and it will start up SQL*Plus for the current TOAD connection and execute the script.
Tags: ,