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 156 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 4 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
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 156 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
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 156 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 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 96 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 95 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 51 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
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 58 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 96 Read More
PL/SQL Developer Jump to new posts
Re: Upload large file MarcielDeg 03/22/24 01:17 PM
4 95 Read More
PL/SQL Developer Jump to new posts
Re: Upload large file MarcielDeg 03/22/24 01:14 PM
I'm trying this solution, but I got the error "ORA-03001: unimplemented feature".

Steps to reproduce:
1. Create an empty table : create table test_clob (XCLOB clob)
2. Create an test insert dml: insert into test_clob values :XCLOB
3. Configure XCLOB variable as your response
4. Execute the update

I tryed the datatypes CLOB and Temporary CLOB, but I got the same problem.
4 95 Read More
PL/SQL Developer Jump to new posts
Keyword Capitalisation Nick Roberts 03/22/24 12:48 PM
There has, I suspect, been a great deal of conversation on the subject of the automatic capitalisation of keywords in SQL comments.

I always hold out hope that AA will implement an option to prevent this occurring in an SQL comment or string literal (whilst still performing it elsewhere in the code).

But that notwithstanding, I want to mention a kind of workaround that might be useful to others.

All you do is to type the letter 'x', and then a backspace (cursor left), and then type. Delete the 'x' when you've finished the comment line.

The 'x' prevents the automatic capitalisation. Very handy.

HTH
1 51 Read More
PL/SQL Developer Jump to new posts
Re: ORA-12637: Packet receive failed Marco Kalter 03/22/24 10:19 AM
PL/SQL Developer uses the Oracle Client, which Oracle SQL Developer does not. This may explain the difference.

Can you go to Help > Support Info and send the text from the "Info" tab page to support@allroundautomations.com?
3 96 Read More
PL/SQL Developer Jump to new posts
Re: Upload large file Marco Kalter 03/22/24 10:16 AM
50MB is probably too large for the text editor that is used by default for JSON CLOB's. You can try the following:

1. Query a record with a smaller (or null) value.
2. Click on the cell button to invoke the Large Data Editor.
3. Click on the "External" tab.
4. Enter .json in the "File extension" field.
5. Select an external application to edit the json file.
6. Enable the "Execute automatically next time" option.
7. Press OK.
4 95 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.023s Queries: 7 (0.007s) Memory: 2.2181 MB (Peak: 2.3272 MB) Data Comp: Off Server Time: 2024-03-29 01:51:11 UTC
Valid HTML 5 and Valid CSS