Active Threads | Active Posts | Unanswered Today | Since Yesterday | This Week
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.
5 143 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 999 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
5 143 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 26 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 26 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 56 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 90 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 92 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 48 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 771 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 56 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 90 Read More
PL/SQL Developer Jump to new posts
Re: Upload large file MarcielDeg 03/22/24 01:17 PM
4 92 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 92 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 48 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 90 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 92 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 159 Read More
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.026s Queries: 6 (0.008s) Memory: 2.2119 MB (Peak: 2.3272 MB) Data Comp: Off Server Time: 2024-03-28 09:26:57 UTC
Valid HTML 5 and Valid CSS