Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
8,080 Comments
Hi Jeff
While the below question is not specific to ORDS, this is about creating a Custom AI Agent using Fusion AI Studio by calling ORDS Rest APIs based on user prompt.
Implemented ORDS APIs on Oracle PaaS Database which is within the Network. Would like to call the Rest APIs in Fusion AI Studio to develop a Custom AI Agent. As the ORDS API requests need to go through the Network, need to whitelist the Oracle IP Addresses (Which is dynamic and have range of IP Addresses). Network Security Team has updated whitelisting range of dynamic IP Addresses is a risk. Any insights how this can be done to integrate Fusion AI Studio with ORDS installed with PaaS Database?
Regards
Giri Manda
Use oracle integration service with any PEs necessary?
Hello Jeff,
i try to use sql developer through ords, connecting with user XXX and executing request on schema HR. when connecting with direct loggin i fire a logon trigger which execute an altr curent schema, so that i don’t have to put the name of the schema HR before the table. i can’t find the solution when using sql developer with ords : do you already face this problem ?
is it possible to simulate the logon trigger or an alter session set current_schema with ords ?
Create synonyms or use schema prefix.
Hi Jeff, do you know if anybody has been able to get the Oracle SQLcl MCP server working with the new 2.0 Claude Code Extension in VSCode? I think I have it properly configured in my settings.json but no joy… I do have it working with Cline so the MCP server is definitely working.
{
“github.copilot.nextEditSuggestions.enabled”: true,
“sqldeveloper.sqlHistory.historyLimit”: 500,
“chat.mcp.discovery.enabled”: {
“claude-desktop”: true
},
“sqldeveloper.telemetry.enabled”: true,
“workbench.colorTheme”: “Solarized Dark”,
“claude-code.useNodeExecution”: true,
“claude.nodePath”: “/usr/local/bin/node”,
“claude-code.environmentVariables”: [],
“claude-code.mcpServers”: {
“SQLcl”: {
“command”: “/Applications/sqlcl/bin/sql”,
“args”: [“-mcp”],
“disabled”: false,
“env”: {
“TNS_ADMIN”: “/Users/REDACTACTED/.adb_wallet”
}
}
}
}
I just tortured myself for 30 minutes to get this working, no joy. I’ve left a similar question on their vs code marketplace.
Thanks Jeff. Glad it’s not just me!
With a little help from Claude himself, I was able to get the Oracle SQLcl MCP server working with the new 2.0 Claude Code Extension in VSCode. The fix was to put a .mcp.json file with the MCP details in the root of my local git project repository. Example below…
(base) username_redacted@Mac test01 % pwd
/Users/username_redacted/GitHub_Repos/test01
(base) username_redacted@Mac test01 % ls -alF
total 40
drwxr-xr-x@ 9 username_redacted staff 288 Oct 7 11:32 ./
drwxr-xr-x 10 username_redacted staff 320 Oct 5 18:16 ../
drwxr-xr-x@ 3 username_redacted staff 96 Oct 7 11:32 .claude/
drwxr-xr-x@ 16 username_redacted staff 512 Oct 7 11:33 .git/
-rw-r–r–@ 1 username_redacted staff 198 Oct 7 11:32 .mcp.json
drwxr-xr-x@ 3 username_redacted staff 96 Oct 5 18:16 .vscode/
-rw-r–r–@ 1 username_redacted staff 9567 Oct 7 11:32 oracle_merge_examples.sql
-rw-r–r–@ 1 username_redacted staff 22 Oct 5 18:16 README.md
drwxr-xr-x@ 3 username_redacted staff 96 Oct 5 18:16 sql_files/
(base) username_redacted@Mac test01 % cat .mcp.json
{
“mcpServers”: {
“SQLcl”: {
“command”: “/Applications/sqlcl/bin/sql”,
“args”: [“-mcp”],
“env”: {
“TNS_ADMIN”: “/Users/username_redacted/.adb_wallet”
}
}
}
}
(base) username_redacted@Mac test01 %
Interesting, how very…intuitive.
Hello Jeff,
SQL Developer(classic) can export connection definitions into a JSON file. Passwords for DB users can be included if you provide a master password. OK.
Is the procedure for password encryption publicly known or it is a hidden secret? If we would like to generate such JSON file manually using a script, how should we generate values of fields:
– password
– ExportKeyChecksum
?
Example of JSON file for one connection generated from SQL Developer:
{
“connections”: [
{
“info”: {
“role”: “”,
“SavePassword”: “true”,
“OracleConnectionType”: “ADVANCED”,
“PROXY_TYPE”: “USER NAME”,
“RaptorConnectionType”: “Oracle”,
“Connection-Color-For-Editors”: “-3801088”,
“ExportPasswordMode”: “Key”,
“NAV_FOLDER”: “APP_DEV_19c”,
“customUrl”: “jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=30)(TRANSPORT_CONNECT_TIMEOUT=15)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=scan_name1)(PORT=3521))(ADDRESS=(PROTOCOL=TCP)(HOST=scan_name_dr)(PORT=3521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DB_service)))”,
“oraDriverType”: “thin”,
“NoPasswordConnection”: “TRUE”,
“password”: “s7yE1KAHHUle6LUm8MkKpESwgi1/Dn9DIPk2OlcAjhdbWCqvwCVH3xak2Tk=”,
“driver”: “oracle.jdbc.OracleDriver”,
“subtype”: “oraJDBC”,
“OS_AUTHENTICATION”: “false”,
“IS_PROXY”: “true”,
“KERBEROS_AUTHENTICATION”: “false”,
“user”: “BAP_INC1036142801_01”,
“PROXY_USER_NAME”: “HR”,
“ExportKeyChecksum”: “yzp3FNBnECyY5KiXLgvzy8EY2Yl72lKAvDtV9nysOCj2lQnz”
},
“name”: “DB1 Proxy account”,
“type”: “jdbc”
}
]
}
No.
If you move over to our vs code extension you could easily do this via sqlcl.
Hello Jeff,
Thanks. We can definitely try the VSCode extension. I can see that the extension shares the same connection definitions with SQLcl and I can use “connmgr import” to import definitions from a JSON file. OK.
How can I generate the JSON file with encrypted passwords included? I mean how can I generate it by my own script, not by SQL Developer.
Can you please point me to some description / documentation?
Use sqlcl to connect, but add the -save and -savepwd parameters
This creates a named connection with your password stored in a cso wallet.
OK. Let’s say that I store my connection into cso wallet. How can I share these connectin definitions with the other developers (~100 people)? Copy of the whole wallet or is there a better way?
Info: We implemented password rotation policy in all environments, so we are searching for an automated solution how to distribute connectin definitions.
Zip up the connections folder, and put it down on the machines in the expected location.
If you’re an Oracle Cloud Customer, you can automate with with our OCI Database Tools Service.
VS Code (SQL Developer Extension) and SQLcl will soon both support sourcing connections not locally, but from your OCI profile, and the Tools Service.
Hello Jeff, I am an OIC developer and our DBAs have implemented SSO security for our Oracle ATP databases. I had been using the extension in VSCode to query our databases and I’m not able to get SSO to work correctly after importing the connections from my SQLDeveloper instance.
Is it possible to use the extension with SSO enabled sign-in using OCI and OKTA required for Oracle ATP databases?
how did you have the connection defined in SQL Developer ‘classic?’
I am running in sql developer v.24.3, simple db query. It’s wrapping at a specific point in the screen, looks like it could be at the 80 character mark, there is more available space after it in the UI output screen. There is a vertical line displayed that marks the wrapping point from top to bottom of the output screen.
After viewing your example for pl/sql output, I took another look at what I’m doing and it is actually pl/sql output not sql output. Specifically I am running SELECT DBMS_METADATA.GET_GRANTED_DDL(‘OBJECT_GRANT’,’AMS_APP_TBL_READ_ONLY_ROLE’) from dual;
I tried running set serveroutput on as well as set linesize and set long and it still wraps the longer lines in the output. I also ran your example with dbms_output.put_line and that displays correctly without wrapping the output.
that returns a CLOB
see this
Hey Jeff,
is it possible to get your Beer data table to try out some things from your posts? (What’s the vector victor)
Kind Regards
Klaus
Possible, but not sure I’m ready to share that, it’s got more than a little PII in there.
Hey Jeff, sometimes I get a vertical line in script output screen where the text will wrap to next line. Set linesize or long doesn’t make any difference. Is there a different setting I need to set for this to show long output lines without wrapping?
Where are you running these scripts?
SQL Developer
SQL Developer Web
SQL Developer extension for VS Code
SQLcl?
And is it for just any string that extends beyond the console/UI area? Or is is wrapping at a specific point, say 80 characters?