Active Threads | Active Posts | Unanswered Today | Since Yesterday | This Week
PL/SQL Developer Jump to new posts
Re: Natural vs alphabetical columnlist Marco Kalter 07/16/24 08:57 AM
At the bottom-left of the Code Assistant there is a button to switch between alphabetical sort order and physical sort order. The setting is persistent, so you only need to set it once.

[Linked Image]
1 36 Read More
PL/SQL Developer Jump to new posts
Natural vs alphabetical columnlist Bart 07/16/24 06:49 AM
I'm truly sorry - I am confused whether it's me, but did something changed regarding the sortordering of dropdown lists of autocomplete (v15)
Currently the dropdown is showing columns alphabetically (not allways, but I can't reproduce when, or when not) which is usually not the natural order. I need the order of the table structure.

Had this changed? Is this is a setting (couldn't find it in the "Code Assistant" tab in preferences)?
It even looks it drops down in natural order and then reorder to alpabetical - but it's in a blink-of-an-eye
It drives me crazy currently - I feel it was always natural - and at some point it recdently it change to alpabetical.

N.B.
When I select "All" to fill out the columns (when it's available, which is not always the case when I need it) the order of columns is natural (according to table structure) again (but I'm not even sure how consistent that is, but I couldn't quickly reproduce.
1 36 Read More
Direct Oracle Access Jump to new posts
Re: WebApi with DOA and Client Net Manager Marco Kalter 07/15/24 09:00 AM
Thanks. Can you send an e-mail to support@allroundautomations.com referring to this forum topic with your license information? We will then send you a possible fix for this issue.
3 94 Read More
Direct Oracle Access Jump to new posts
Re: WebApi with DOA and Client Net Manager GustavoOliveira 07/12/24 02:16 PM
Sorry,
We are using:
- Delphi Seatle
- DOA 4.1
- Oracle Database 12c Standard Edition
3 94 Read More
PL/SQL Developer Jump to new posts
Re: Recall statement fabrice 07/12/24 07:21 AM
Perhaps you can use option recall statement in PLD : menu Edit \ Recall statement (CTRL + E)
1 81 Read More
PL/SQL Developer Jump to new posts
Recall statement amirosh 07/11/24 05:05 PM
I am working with version 12.0.3.1821
I usually have several SQL queries open.
Every time the computer restarts and I restart the application, I am asked whether to restore the open queries and I can choose from several save dates.
Then after the selection I get my queries back.
Today something happened and all my queries were deleted and if after restarting the computer I don't get the message that the queries have been restored.
In the folder: C:\Users\USERNAME\AppData\Roaming\PLSQL Developer 12\PLS-Recovery I found several files including: PLSRecall.dat + desktop.cfg.
But I can't restore them into the interface.
How can the restoration be performed?
I also checked in options > Recall statement and the folder name is set correctly.
1 81 Read More
PL/SQL Developer Jump to new posts
Re: Version 16 Marco Kalter 07/11/24 08:58 AM
Yes, this will be addressed!
5 589 Read More
PL/SQL Developer Jump to new posts
Re: Version 16 TheOracle 07/10/24 01:45 PM
I'm with Gore on this one. Performance is the biggest thing the people I work with complain about second to the memory leaks and crashes.
This tool is way better than Oracle's SQL Developer in features but when a Java app (Oracle SQL Developer) is faster than a windows app (Allround PL SQL Developer) you know something needs improvement.
5 589 Read More
PL/SQL Developer Jump to new posts
Re: Version 16 Marco Kalter 07/08/24 01:14 PM
Both will be covered.
5 589 Read More
PL/SQL Developer Jump to new posts
Re: AI support Marco Kalter 07/08/24 01:13 PM
It will be available for public beta testing in a few months.
6 732 Read More
PL/SQL Developer Jump to new posts
Re: Version 16 Gore 07/08/24 12:30 PM
Beside colored icons :), my top expectations for version 16 would be speed and stability!
5 589 Read More
PL/SQL Developer Jump to new posts
Re: AI support Heiko12345 07/08/24 12:11 PM
When will version 16 be available for testing
6 732 Read More
PL/SQL Developer Jump to new posts
Re: How do I connect my database? jhughes 07/05/24 01:26 PM
It is mentioned via Help -> User's Guide from the GUI. Section 3 is "Logging on to an Oracle database"
2 136 Read More
PL/SQL Developer Jump to new posts
Re: How do I connect my database? fabrice 07/04/24 07:22 AM
PL/SQL Developer needs something else to be able to connect to a DB,
You can use a client DB or Instant client, both from oracle..
2 136 Read More
PL/SQL Developer Jump to new posts
How do I connect my database? Lauren York 07/03/24 06:46 PM
Hi. I downloaded PL/SQL Developer as a trial. I am unable to connect my database and do not see any helpful instructions. In other software I am testing (for example, DBeaver) there is a settings window where I enter the Host, Port, etc. However, I do not see where/how to do that in PL/SQL Developer. Any suggestions are appreciated.
2 136 Read More
Direct Oracle Access Jump to new posts
Re: WebApi with DOA and Client Net Manager Marco Kalter 07/03/24 09:09 AM
Can you let me know your Delphi version and Direct Oracle Access version?
3 94 Read More
Direct Oracle Access Jump to new posts
WebApi with DOA and Client Net Manager GustavoOliveira 07/02/24 01:03 PM
Hey guys,

I'm developing an Delphi API to internal requests at work. The api is hosted on a windows server that is not the same as the oracle database.

When I receive more than 10 simultaneous requests I have several problems with crashes and access violations reported.

I read something about Session's Connection Pool and ThreadSafe, but I couldn't put it into practice.

My question is whether DOA Session is capable of managing this type of task (Web Api)
3 94 Read More
Direct Oracle Access Jump to new posts
Re: Problem with DOA+OCI19 on AMD processor Louarn 06/28/24 01:47 PM
Forgot my previous comment; from Oracle web site, when registered, you can access to the patch (available for entreprise & Standard edition)

The bug is refrenced, but impossible to have details on it.

Thanks Tailor, our previous search did not let us find it, good game !
6 1,866 Read More
Direct Oracle Access Jump to new posts
Re: Problem with DOA+OCI19 on AMD processor Louarn 06/28/24 01:26 PM
Hello all,

We are facing the exact same situation, but not using DOA component (we are using Devart - ODAC ones).

Not all values are affected, it seems to be stored corrupted in DB.

Divide the corrupted data by 1 => value is Ok (this time it was "3.23").
Value is stored with the "101" terminal: 193,4,23,101
Instead of 193,4,24.


Did you find any solution to this issue ?
6 1,866 Read More
PL/SQL Developer Jump to new posts
Re: service contract base version 15 for v14.6? Marco Kalter 06/24/24 09:23 AM
You can contact support@allroundautomations.com for registration information that is compatible with older PL/SQL Developer versions.
1 143 Read More
PL/SQL Developer Jump to new posts
Re: PL/SQL Beautifier Marco Kalter 06/24/24 09:22 AM
This is indeed not possible. The beautifier will place each case on a separately indented line. I have added this to the list of enhancement requests.
5 331 Read More
PL/SQL Developer Jump to new posts
service contract base version 15 for v14.6? fraenkg 06/22/24 06:01 PM
Hi Marco,

I recently renewed my service contract (after 3 years, that's how long the previous one ran). I saw that the base version is 15.0 - and that would work. However, I am currently using version 14.6. I cannot activate the service for this version. When the program starts, I am informed that the service contract has ended and that a new one must be requested if necessary. Do I need an additional agreement for v14?

Many greetings, Frank
1 143 Read More
PL/SQL Developer Jump to new posts
Re: Auto-Generated ERD Diagrams Jim Oriotis 06/21/24 01:04 PM
I didn't thing there was an auto-generate, but I was hoping I missed something in the documentation.

No worries.

Do you have a document specifying the complete format of a .pdd file?

I could query dba_objects and generate the .pdd file using SPOOL if I knew the .pdd structure/syntax as it seems to be a PLAIN TEXT file.
2 155 Read More
PL/SQL Developer Jump to new posts
Re: PL/SQL Beautifier raam94 06/21/24 09:41 AM
SELECT

CASE
WHEN caus = 11 THEN 1
WHEN caus = 12 THEN 2
ELSE caus END caus ,
SUM(numero) numero,
SUM(importo) importo
FROM TAB
5 331 Read More
PL/SQL Developer Jump to new posts
Re: PL/SQL Beautifier Marco Kalter 06/21/24 08:42 AM
I meant the complete SQL or PL/SQL statement with the case expression.
5 331 Read More
Page 1 of 2 1 2
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.048s Queries: 6 (0.017s) Memory: 2.3363 MB (Peak: 2.4039 MB) Data Comp: Off Server Time: 2024-07-17 12:41:06 UTC
Valid HTML 5 and Valid CSS