Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 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
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 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