Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 208 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 522 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 490 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.2K Development
- 7 Developer Projects
- 128 Programming Languages
- 289.9K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 260 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 226 Portuguese
Version 19.3.4 now available - please try it out and let us know your feedback
Hi,
Today we released Oracle Developer Tools for VS Code version 19.3.4. Please try it out and let us know what you think:
https://marketplace.visualstudio.com/items?itemName=Oracle.oracledevtools&ssr=false#overview
This release adds new features and fixes that you brought to our attention in this forum and elsewhere. Thank you for your involvement in making this product better. Please keep the feedback coming!
Some key features that were brought about by your feedback include:
- Script execution integration with the Problems panel including navigation to error locations and highlighting of error lines
- Breadcrumb support enabling navigation within scripts
- Materialized view support in Oracle Explorer
- Setting to change delimiter for CSV file generation
- Directory Server (LDAP) multiplatform support (Windows, macOS, Linux)
- Results from script execution use session NLS settings
Additional features:
- Generate SELECT, INSERT, and DELETE SQL statements for relational tables from Oracle Explorer
- Describe context menu on the Oracle Explorer nodes shows object metadata
- Show data on all different types of tables and views in Oracle Explorer
- Icons added to Oracle Explorer nodes
- Tooltip support for data grid
- Copy menu item for individual cells in data grid
I am looking forward to hearing your feedback to help make this product better. Please add your comment below or start a new thread. 😁
Answers
-
some great news (breakcrumb and materialized views).
I'm watting for format code , some completion improve and oracle ORDS support , and some other things,
but things going well
-
I can't seem to see it in VSCode, is there a minimum version required?
-
Thanks for bringing this to my attention! You are correct. VS Code needs to be updated to version 1.51.1 or later before you will see Oracle Developer Tools for VS Code 19.3.4 in the marketplace. Please go to the VS Code menu and choose Help->Check for Updates.
-
Thanks, unfortunately my company packages and distributes VSCode centrally which means getting it updated is a nightmare, I'll try and find a way to test out the new stuff!
-
Hi had the same problem with my company ( package update on 2-3 years) for vscode this is not possible, because this software is monthly dev iteration, and oracle and others company can't deal with that (no LTS for vscode)
-
Once again great release. I've had a few hours in now and can give some feedback.
Plain old this is awesome Feedback:
Materialized views -> huge win for me I really appreciate them in the explorer rather than me having to do selects off the dictionaries if I want to find them.
Hints -> are great, did not know those were on the roadmap but already a great help.
NLS Settings and the Output In general seems much better. Tables are sized more reasonably by default.
Problems tab and peak issues looks really nice and well done!
Constructive Feedback:
It seems like the object explorer is still requiring that you have edit access to a package or package body to view the source. If you have access to a DB but not edit to a specific schema/user you can see the package is there but if you right click it to open it nothing happens. In SQL Developer i can view the package body just not save it.
@Adil D. as a temp fix you can try mp.vscode-oracle-format another extension. It requires your local machine have the SQLcl installed properly and in the path where vs code can find it.
-
Hi, having some issues with connecting after update with no changes to my settings. I have an advance connection type with a connection string in, username and password (all correct details) and was able to connect in 19.3.3, when it updated to 19.3.4 it is now just throwing a connection timed out error.
I also have 2 proxy connections that use a ODP.NET string, both of these have the same issue?
-
Are you on macOS? If so, please install .NET Runtime 5.0 and then restart Visual Studio Code:
If you are not on mac, you don't need to upgrade.
-
Hi,
Nice update! I just want to report an issue whith accents strings opening a package from the Oracle explorer:
Could be the encoding you are using to open the file, i have configured WIN 1252 for .sql, and .plsql.
Cheers
-
Hi, are you saying that the characters are not rendering correctly? If so, which characters?