Active Threads | Active Posts | Unanswered Today | Since Yesterday | This Week
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 154 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 3 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
0 22 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,010 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
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 58 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 95 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 94 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 50 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 773 Read More
Direct Oracle Access Jump to new posts
Re: Oracle 19, String vs WideString Marco Kalter 03/22/24 10:01 AM
I have added this to the list of enhancement requests. We will continue to support & developer DOA in the future.
7 161 Read More
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.022s Queries: 7 (0.005s) Memory: 2.2014 MB (Peak: 2.3272 MB) Data Comp: Off Server Time: 2024-03-28 23:39:00 UTC
Valid HTML 5 and Valid CSS