Discussions
Categories
- 384.6K All Categories
- 2.5K Data
- 556 Big Data Appliance
- 1.9K Data Science
- 451.4K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 561 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 166 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 536 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
New release: 21.4.0 - featuring PL/SQL debugger and enhanced intellisense
We've just released version 21.4.0. Please try it out and let us know what you think by starting a new thread here in the forum.
Take a look at my recent blog covering key new features and a walkthough for getting the PL/SQL debugger up and running:
Key features in this release (driven by your feedback and requests):
- PL/SQL Debugger - Debug PL/SQL in stored procedures, functions and packages using Visual Studio Code's native debugging features. Use menus to compile PL/SQL for debugging, to step into PL/SQL, and to run to a breakpoint. Enable External Application Debugging to listen for and debug PL/SQL procedures and functions called by applications or SQL scripts. See the blog entry above for a step by step walkthough.
- IntelliSense support for table/view aliases
- Smarter IntelliSense: Continuous parsing of SQL fragments being typed enables much better context sensitive autocomplete suggestions
- Editor now supports hover, Go to/Peek Definition, Go to/Peek Type Definition and Go to/Peek Implementation
- Support for User Defined Types within a select list (for example, queries against tables that include Oracle Spatial types)
- Procedure/Function input parameter dialog improvements including keyboard only entry (no mouse clicks required)
- SQL Parameter Binding Dialog is displayed with a request for input values when SQL is executed that includes undefined bind and substitution variables
- Generate Create SQL menu item in Database Explorer outputs a CREATE SQL statement for a table or view
- Support for .NET 6 which enables ARM64 processors such as Apple Silicon
Additional features:
- Support for TLS based database connections without a wallet
- Support for single sign-on (SSO) with OCI IAM when connecting to Oracle Autonomous Database
- PL/SQL Compiler Settings page
Make sure you are on Visual Studio Code version 1.51.1 or later. You can check the version by using the Help->About menu item. To upgrade select Help->Check for Updates. Older VS Code versions will not see this 21.4.0 update in the Marketplace.
Check out the quickstart to get started and for more details on these feature enhancements.
https://www.oracle.com/database/technologies/appdev/dotnet/odtvscodequickstart.html