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,239 Comments
What would cause the ‘Run Statement’ command to return seemingly garbage script output?
I have a very simple query that I’m running against a view. I’m running it in its SQL worksheet, using the ‘Run Statement’ command. I’ve tried running it as different schema, and on dev vs test (which both have the same view definition).
When I run it limiting by ID, I get the expected result(s).
However, when I run it without that limitation, instead of giving me query results in the ‘Query Results’ tab, it jumps me over to the ‘Script Output’ tab and outputs:
{
“env”: {
“defaultTimeZone”: “Z”
},
“items”: []
}
Simplified example: (columns etc changed for privacy):
–this runs as expected
select id
from other_schema.weird_view
where f_key = 92
and id = 123;
–this does not
select id
from other_schema.weird_view
where f_key = 92;
If I wrap the whole thing in PLSQL:
SET SERVEROUTPUT ON;
BEGIN
FOR record_item IN (
select id
from other_schema.weird_view
where f_key = 92
) LOOP
dbms_output.put_line(‘id: ‘||id);
end loop;
end;
/
I get the actual error message (“ORA-01422: exact fetch returns more than requested number of rows” if that matters)
If I run the same statement in stand-alone SQL Developer, I also get actual error message.
Do I have something mis-configured in SQL Dev extension? Is this a bug?
Definitely sounds like a bug.
The definition of the view and the underlying table data types probably come into play. So I need a test case. Create a dummy table/view that simulates your real world example, and see if that triggers the same bad behavior.
You can also have a look at the Output panel with the filter set to ‘SQL Developer Log’ for more info.
Here is some test data that does the same weird thing: (I’m curios if it does it for you, too)
create table test_table
as
select 1 as id, 123 as fkey from dual
union all
select 2 as id, 456 as fkey from dual
union all
select 3 as id, 456 as fkey from dual;
create table test_table2
as
select 123 as fid, ‘hi’ as msg from dual
union all
select 456 as fid, ‘yo’ as msg from dual
union all
select 789 as fid, ‘sup’ as msg from dual;
create or replace function test_function (
p_fkey in number
) return number is
v_id number;
begin
select id
into v_id
from test_table
where fkey = p_fkey;
return v_id;
end;
/
create or replace view test_view1 as
select id,
fid,
msg
from test_table2
left join test_table
on test_table.fkey = test_table2.fid;
create or replace view test_view2 as
select id,
fid,
msg
from test_table2
left join test_table
on test_table.id = test_function(test_table2.fid);
select test_function(123)
from dual;
/* the above returns the expected value of 1 in the query result tab */
select test_function(456)
from dual;
/* above returns the expected error in the query result tab:
Error at Line: 1, Column: 8
SQL Error: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “TEMPO.TEST_FUNCTION”, line 44
*/
select *
from test_view2
where fid = 123;
/* above returns expected rows in the query result tab:
ID FID MSG
1 123 hi
*/
select *
from test_view2
where fid = 456;
/* above leaves the query results tab unchanged and returns the following weird output to script output tab:
{
“env”: {
“defaultTimeZone”: “Z”
},
“items”: []
}
*/
I get the same in SQLDev as I get in SQLPlus
SQL*Plus: Release 23.0.0.0.0 – Production on Thu Aug 13 19:33:43 2026
Version 23.7.0.25.01
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Last Successful login time: Wed Aug 12 2026 16:52:41 +00:00
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 – Develop, Learn, and Run for Free
Version 23.7.0.25.01
SQL> select test_function(456)
from dual; 2
select test_function(456)
*
ERROR at line 1:
ORA-01422: exact fetch returned more than the requested number of rows (0)
Help: https://docs.oracle.com/error-help/db/ora-01422/
SQLDev
Error at Line: 1, Column: 8
SQL Error: ORA-01422: exact fetch returned more than the requested number of rows
ORA-06512: at “HR.TEST_FUNCTION”, line 6
*Cause: The cause is one of the following
1. A SELECT statement was executed in the exact fetch
mode and returned more rows than requested.
2. In PL/SQL, a SELECT INTO statement returned more than one row.
3. In PL/SQL, a DML RETURNING INTO statement
returned more than one row.
*Action: Choose the action corresponding to the cause as numbered
1. Increase the number of rows requested to accommodate the
number of rows returned;
or omit the exact fetch mode on the fetch call.
2. In PL/SQL, use a FOR loop to process the rows.
3. In PL/SQL, use BULK COLLECT to return values into a table.
*Params: 1) requested_rows
More Details: https://docs.oracle.com/error-help/db/ora-01422/
What do you get when you run it in VSCode via the SQL Developer ext? (That’s where I’m seeing the weird behavior, but I see now that wasn’t super clear from my first post)
We’re ‘eating’ the ORA- error, and bringing back the partial JSON response. That’s a bug, will log.
Hi Jeff,
I am using the SqlDeveloper extension on VS Code, i am up to date with the versions.
I just can’t seem to succeed in creating folders for my connections.
I do have an ‘add folder’ link. When I use it, I get the option to give the folder name, but after I give one and enter it, nothing happens. I do no see a folder appear, I do not get a list when I select a connection and try to add it to a folder.
I don’t know if it is correlated, but when i first installed the extension, I imported my desktop connections (which *did* have folders).
I tried reinstalling the extension, but that doesn’t help.
thanks in advance,
Marc
Sounds like you have an OS file permission issue. The Output panel would display those, making sure to set the category to SQL Developer – Log.
You might need to either delete your AppData folder and let the extension/Windows recreate it, or grant the privs – maybe try running VS Code as an Admin? There are posts/solutions on the SQLDev/VS Code forum that cover this as well.
Hi Jeff,
I want to connect to a database via native network encryption with AES256 resp. SHA256 and ALLOW_WEAK_CRYPTO_CLIENTS = FALSE. The developer showed me an ORA-12269. Im looking for the information which sql developer version does support this connection type. Is it possible to update the jdbc driver of the developer so that such a connection type works as expected?
Thanks & regards
Axel D.
What ‘developer’ are we talking about?
Our SQL Developer extension for VS Code’ has a very recent copy of the JDBC driver
Driver Name: Oracle JDBC driver
Driver Version: 23.26.2.0.0
Hello Jeff
i have ORDS20.3 running and want to upgrade to ORDS25.1
i know how to proceed with upgrade but finding difficulty in rollback steps.
Can you please guide me on how to safely rollback to ORDS20.3 if there is an issue after upgrade to 25.1
TIA
Ilyas
Why upgrade to old software?
For rollback you have two options, a database restore, or an uninstall, install of ords. If you go with 2nd option, make sure you have your rest apis, oauth2 clients, etc backed up as sql scripts you can reapply.
Hello Jeff…..can you please have a look and let me know on this.
I already answered.
Hi Jeff. For “patching” ORDS with latest (26.2.1.190.1402), can I just run ords install after staging on the weblogic host and adjusting environment variables for new version? Or do I need to redeploy ords.war and i.war again?
Thanks in advance.
-abe
26.2.1 from what version?
From 26.1 and earlier you need to run an upgrade, that will uodate the database objects and plsql apis.
Any version, you need to deploy the war file. Thats the ords java code.
Thank you, sir. This is to be applied on top of: 26.1.2.r1401916.
-abe
You need a full upgrade then.
I want to thank you for keeping afloat the legacy version of sqldeveloper. It’s still the best one available.
In the stand-alone SQL Developer, there is a ‘Toggle ANSI/Oracle Joins’ feature. Is this available in the VSCode extension version?
No/Not yet
Is there a way to get my huge, old sql history from sql developer (legacy) to the sql history of the vs code extension? I found both directories, but the file structure seems to be different and needs to be converted. Is any migration/import script available?
No, but like you said, you have the two files. You could use an AI/LLM to generate some Python to do that conversion for you.
@Jeff, thanks for your answer! I created a small Python script to do the work and it looks good so far. Is there any rule or logic behind these 6-digit filenames of the vs code extension? DO you use any hashes based on the file content used from the extension for indexing etc.? Or does the extension simply create uuids to get unique file names.
Hi Jeff,
I’m trying to figure out whether the SQL Developer VS Code extension supports debugging PL/SQL from APEX applications.
The classic Oracle SQL Developer uses JDWP for PL/SQL debugging:
https://www.slideshare.net/slideshow/debugging-plsql-from-your-apex-applications-with-oracle-sql-developer/146095763
Does the SQL Developer VS Code extension already support this feature?
Finally moving from SQL Developer Version 24.3.1.347 to VS Code with the SQL Developer Extension. And I see your post from Jan. 2026 about canned reports being available. My question is: what about user reports? Will that be added or is there another way to do user reports in VS Code with the SQL Developer Extension?
We’re going to enhance the SQL Notebooks to offer what User Defined Reports used to.