Skip to content

Instantly share code, notes, and snippets.

@mortenbra
Last active February 6, 2020 08:48
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save mortenbra/9d7bd2147b02ae8fa2e14dbc38935e5e to your computer and use it in GitHub Desktop.
Save mortenbra/9d7bd2147b02ae8fa2e14dbc38935e5e to your computer and use it in GitHub Desktop.
VS Code task runner configuration for PL/SQL
{
"version": "0.1.0",
// The command is a shell script
"isShellCommand": true,
// Run sqlplus via a batch file
"windows": {
"command": "_run_sqlplus.bat"
},
"osx": {
"command": "./_run_sqlplus.sh"
},
"linux": {
"command": "./_run_sqlplus.sh"
},
// first argument is the database connection string
// second argument is the file to execute (ie the current file)
"args": ["username/password@//hostname:1521/xe", "@\"${file}\""],
// do not switch to the output pane automatically
"showOutput": "silent",
// use this to get any database errors (from user_errors view) listed in the "Problems" pane in VS Code
"problemMatcher": {
"owner": "plsql",
"fileLocation": ["relative", "${fileDirname}"],
"pattern": [
{
"regexp": "(.*) (\\d*)\/(\\d*) (.*?) (.*)",
"severity": 1,
"line": 2,
"column": 3,
"file": 4,
"message": 5,
"loop": true
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment