Skip to content

Instantly share code, notes, and snippets.

@mortenbra
Created May 20, 2021 08:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mortenbra/05d88cd0181a3dd1b0436f32c51d264a to your computer and use it in GitHub Desktop.
Save mortenbra/05d88cd0181a3dd1b0436f32c51d264a to your computer and use it in GitHub Desktop.
Visual Studio Code build task for PL/SQL, with error/problem output
{
"version": "2.0.0",
// Run sqlplus via a batch file
"windows": {
"command": "./_run_sqlplus.bat"
},
"osx": {
"command": "./_run_sqlplus.sh"
},
"linux": {
"command": "./_run_sqlplus.sh"
},
"presentation": {
"reveal": "never", // never,silent,always
"panel": "shared" // new,shared,dedicated
},
"tasks": [
{
"label": "Build PLSQL code",
"type": "shell",
"args": [
"scott/tiger@//myserver.example.com:1521/xe",
"@\"${file}\""
],
"problemMatcher": {
"owner": "plsql",
"fileLocation": [
"relative",
"${fileDirname}"
],
"pattern": [
{
"regexp": "(.*) (\\d*)/(\\d*) (.*?) (.*)",
"severity": 1,
"line": 2,
"column": 3,
"file": 4,
"message": 5,
"loop": true
}
]
},
"group": {
"kind": "build",
"isDefault": true
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment