Happy release day! We’re a bit tardy on our 3rd quarter update, but I’m going to blame corporate red tape and perhaps a bit of Cloud World Hangover.
So, what do you need to know?
Friendlier, more helpful error messages
The enhanced error messages are here, with links to our new error message portal.
CODESCAN now has support for PL/SQL and SQL Coding Guidelines
You can either –
SET CODESCAN ON for interactive feedback, a la –
Scan an entire directory of your source code.
I exported all the PL/SQL from my ADMIN schema in my 19c Always Free Autonomous instance.
I asked for both JSON and TEXT reports, that looks like this –
The rules are community sourced, you can find them HERE. And there is an option to avoid rules you don’t agree with, more on that in a follow-up post.
There are many, many bug fixes included in 23.3, but I’m going to highlight just one of those in this post:
IMPORTING AUTONOMOUS (WALLET) CONNECTIONS FROM SQL DEVELOPER FAILS
I have an Always Free Autonomous Database connection using mTLS, and I have a connection defined for my ADMIN account in SQL Developer.
I want to import it, like so –
And now I’m going to IMPORT this connection to SQLcl’s connection ‘store’ using the CONNMGR command.
If I run the CONNMGR list command, I can see what’s available, and then make my connection!
Tip: avoid the HIGH & MEDIUM services unless you really need it. The parallel stuff can get in the way of day-to-day development work.
There’s more to go over here, but we’ll cover that later.
Enjoy the release! Our next update will be 23.4, scheduled for early December 2023.