Oracle Developer Tools for VS Code

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)

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?

Hi, I dont think the issue is related to the rendering process, this could be an encoding problem. I open the .sql file as win 1252 and it looks correctly:
But, when I load it from Oracle Explorer, The extension open the file with a different enconding (maybe UTF-8, i suppose), even if I have configured .plsql to open with WIN-1252 (ANSI):
If I press "save to database" the package keeps that wrong encoding.
This happens with any charater that is not supported by UTF-8 like "á, é, í, ó, ú" etc.

Hello, had potential enhancement for a future release suggestion now that the object explorer is getting so awesome we could make it a bit better.

Right now if you have multiple similar connections say a test and live environment. Its tough to tell which one you've arrived at if you are searching the explorer. A nice add on would be on the fly-over for an object to give its fully qualified name?

Instead of mouse over of a table saying TABLE_NAME perhaps say
SCHEMA_NAME.TABLE_NAME@DATABASE_NAME ?
Nothing critical but it would be nice!

I'm having some performance issues; when I drop a certain query in TOAD, it runs in about 50 seconds. If I drop that same exact query in the Oracle VSCode Extension, it just runs and runs and never ends. Any ideas? The specific result set it returns is small, 2 rows by 167 columns

Hi there,
Are you sure you are running against the same exact database? Some organizations have multiple "test" databases that are very similar. You should verify the connection strings, and if tnsnames.ora is being used make sure they are identical and coming from the location you think they are coming from.
You mention "drop" but it sounds like you are doing a select? Could you please provide the select statement you are executing? Could you also issue a "describe objectname" for the schema objects being used?
Please let me know what OS you are using, what version of our extension you are using, and what version the database is.
Finally, if possible you should ask your DBA if there is any tracefile being generated on the server when you run the query. If you hit a bug of some kind, it may produce an error in a tracefile in the database server.

After the update, my timestamp format changed to DD-MMM-RR. How do I default this back to YYYY-MM-DD HH24:MI:SS? For now, I have to run ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' for every session. How do I set this as the default moving forward for the Visual Studio Code extension?

Hi,
As you point out, in this release we fixed an issue where we were not honoring the session nls_date_format.
If you don't want to set this every time manually, can you get your DBA to create a login trigger for your user and have the trigger set nls_date_format?
We are hoping to add a "login.sql" type option in a future release that will allow you to run sql each time you connect using this extension.

Thanks for the suggestion. I will add this to our list.

You and the whole team are awesome.

Hi, all the latest improvements are welcome. One major feature missing is filters in the explorer for packages, views etc. Currently when I click on them it takes a very long time for them to open as they are loading all the packages. If we have a filter like it is in the SQL Developer where it loads only the ones in the filter it will make this much more usable.
Thank you.

Thanks for letting me know. Explorer Filtering is a popular request and we hope to do something there. Please make sure you are on version 19.3.4 as we did do some performance optimizations, however I suspect they will not help you in this situation.

I can not connect to my databases any more, always getting a timeout. The databases themselve work correctly, I can connect through SQL Developer. Any ideas where to start searching (logfiles etc.)?
Oracle Version: 12c (12.1.0.1.0 - 64 bit)