Active Threads | Active Posts | Unanswered Today | Since Yesterday | This Week
PL/SQL Developer Jump to new posts
Re: Beautifier creates redundant whitespace on empty lines ThorinDwarf 03/29/24 11:58 AM
It's 2024, ver.15 and we still have this bug!?
9 8,996 Read More
PL/SQL Developer Jump to new posts
Re: New feature doesn't work Marco Kalter 03/29/24 10:34 AM
There should be an "Output" button on the status line after executing a PL/SQL Block with dbms_output. This button does not seem to appear though. We'll fix it.
1 30 Read More
Direct Oracle Access Jump to new posts
Re: DOA - Delphi errors with Oracle 21 altink 03/28/24 10:52 PM
Thank You very much Mr. Kalter

For sure I will buy and upgrade to DOA 4.1.4. Can't think of working Delphi->Oracle without it.
Same for PL/SQL Developer.

Keep the great job

best regards
Altin
6 161 Read More
Direct Oracle Access Jump to new posts
ORA-28040: No matching authentication protocol altink 03/28/24 10:46 PM
Hi

When I try to connect with an Oracle 11g R2 Classic Client to an Oracle 19c DB, with both:
PL/SQL Developer 11.0.4
DOA Runtime (Design-time - Delphi TOracleSession) 4.1.3.5 - Delphi 10.1 Berlin

I get error ORA-28040: No matching authentication protocol
(which can be fixed DB-side by adding SQLNET.ALLOWED_LOGON_VERSION=9 on sqlnet.ora - but this is not the point).

When on Run-Time from my app.exe, made with DOA and Delphi same version, I am trying to connect to an Oracle same 19c DB,
I do not have ORA-28040, but do logon successfully.

What I have noticed is that in the Full Oracle Client 11g there is no oraociei11.dll.
But it is on the same dir of my app.exe, as I got it together with oci.dll from Oracle 11g Instant Client.
If I remove oraociei11.dll from the folder of app.exe, I get the same behavior: ORA-28040

I wander what is this all about

best regards
Altin
0 6 Read More
PL/SQL Developer Jump to new posts
New feature doesn't work Philippe Malera 03/28/24 09:30 AM
On this page :
https://www.allroundautomations.com/products/pl-sql-developer/features/new-features-pl-sql-13-0/
In chapter : PROGRAM WINDOW ENHANCEMENTS
It says :
DBMS_Output is now retrieved when executing a PL/SQL Block.

But I cannot find the "Output tab" in my Program window (used for testing plsql block).
I'm using version 15.

Refer tos this request :
https://forums.allroundautomations.com/ubb//ubbthreads.php?ubb=showflat&Number=56245#Post56245
1 30 Read More
Direct Oracle Access Jump to new posts
Re: DOA - Delphi errors with Oracle 21 Marco Kalter 03/28/24 09:26 AM
Yes, this will work fine.
6 161 Read More
PL/SQL Developer Jump to new posts
Re: Cannot scroll while query in progress LloydO 03/27/24 07:27 PM
I sent you the Debug.txt in a pm.
7 1,014 Read More
Direct Oracle Access Jump to new posts
Re: DOA - Delphi errors with Oracle 21 altink 03/27/24 06:21 PM
Thank You very much Mr. Kalter

One last question:
Does DOA 4.1.4 supports Oracle 10g release 2 ?

best regards
Altin
6 161 Read More
PL/SQL Developer Jump to new posts
Re: Find and replace with "Preserve case" option Marco Kalter 03/27/24 09:43 AM
This is currently not possible. It would require multiple case-sensitive search & replace operations.

I have added this to the list of enhancement requests.
1 31 Read More
PL/SQL Developer Jump to new posts
Find and replace with "Preserve case" option Bart 03/27/24 07:18 AM
Hi!
It's pretty trivial for modern editors nowadays, so I might have missed the option.
If I didn't miss it, I really like to have the option in the editor to REPLACE with keeping case as is.
Example:

declare
l_table_alias varchar2(3) := 'USR';
begin
l_usr_id := -1;
end;

After find and replace "usr" with "col" and ticking the "PRESERVE CASE" option, the result would be:
declare
l_table_alias varchar2(3) := 'COL'; --currently this will be 'col'...
begin
l_col_id := -1;
end;
1 31 Read More
PL/SQL Developer Jump to new posts
Re: USER DEFINED FOLDER Marco Kalter 03/25/24 10:07 AM
You can indeed only use columns from the all_objects view in your folder. You can however create a stored function that returns the table size based on the table owner and name, an use that function in the order by clause of your folder.
1 60 Read More
PL/SQL Developer Jump to new posts
Re: ORA-12637: Packet receive failed Marco Kalter 03/25/24 10:00 AM
Great, thanks for the update!
3 98 Read More
PL/SQL Developer Jump to new posts
Re: Upload large file Marco Kalter 03/25/24 09:59 AM
I cannot immediately reproduce this ORA-03001 issue. To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 15\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 15).
4 97 Read More
PL/SQL Developer Jump to new posts
Re: Keyword Capitalisation Marco Kalter 03/25/24 09:54 AM
Keywords are not capitalized in comments or string literals when I try this. Can you let me know the exact steps to reproduce this issue?
1 52 Read More
PL/SQL Developer Jump to new posts
Re: Export to CSV with no headers CoffeeK1d 03/23/24 03:45 PM
The "User-defined Text Export" plug-in can do this. With that plug-in, you will have a new "User-defined file" export method with an option to include headers.
4 774 Read More
PL/SQL Developer Jump to new posts
USER DEFINED FOLDER Stephen Young 03/23/24 02:12 PM
I've defined my own folder in the Browser - a list of tables - but - is it possible to order these by size (extents)? If I understand the documentation correctly, then ordering can only be done on columns in the all_objects view .....
1 60 Read More
PL/SQL Developer Jump to new posts
Re: ORA-12637: Packet receive failed zstringer 03/22/24 04:12 PM
Our Oracle team figured out a solution. Include the following line in sqlnet.ora:

DISABLE_OOB=ON

That seems to have fixed the problem.
3 98 Read More
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.025s Queries: 7 (0.007s) Memory: 2.2110 MB (Peak: 2.3272 MB) Data Comp: Off Server Time: 2024-03-29 14:10:31 UTC
Valid HTML 5 and Valid CSS