Active Threads | Active Posts | Unanswered Today | Since Yesterday | This Week
Direct Oracle Access Jump to new posts
Re: Support DOA for C++ Builder 12.1 Marco Kalter 04/25/24 09:17 AM
Indeed. This is not what I intended to imply. As stated: we're looking into the option for a clang package (Windows 64-bit Modern platform).
3 23 Read More
Direct Oracle Access Jump to new posts
Re: Support DOA for C++ Builder 12.1 Markus Donath LE 04/24/24 01:01 PM
My question concerned the Windows 64-bit Modern platform. This is definitively not binary compatible.

Markus
3 23 Read More
Direct Oracle Access Jump to new posts
Re: Support DOA for C++ Builder 12.1 Marco Kalter 04/24/24 09:39 AM
RAD Studio 12.1 is binary compatible with 12.0, so you can install the current RAD Studio 12 packages.

We're looking into the option for a clang package (Windows 64-bit Modern platform).
3 23 Read More
PL/SQL Developer Jump to new posts
Re: How to move multiple rows in Editor Marco Kalter 04/24/24 09:03 AM
Do you mean the text editor? If so: select the lines, press Ctrl-X to cut them, go to the new location, and press Ctrl-V to paste the lines again.
1 42 Read More
Direct Oracle Access Jump to new posts
Support DOA for C++ Builder 12.1 Markus Donath LE 04/24/24 08:57 AM
Will DOA support C++ Builder 12.1, especially the modern clang compiler?

Best regards,

Markus
3 23 Read More
PL/SQL Developer Jump to new posts
How to move multiple rows in Editor Punit 04/23/24 08:11 PM
Hello,

How to move multiple rows in Editor?

Version is : 15.0.0.2500

Thanks & Regards,
Punit
1 42 Read More
PL/SQL Developer Jump to new posts
Re: NetSuite Ankit 04/16/24 11:48 AM
Also Visit Ledger Labs provide NetSuite Services
10 5,531 Read More
PL/SQL Developer Jump to new posts
Re: Empty ACTION in v$session Marco Kalter 04/16/24 08:37 AM
Could it be that your Oracle user has a synonym, a view, or a table with the name V$SESSION? This would explain the different results when querying the sys.v_$session view.
1 80 Read More
PL/SQL Developer Jump to new posts
Empty ACTION in v$session DoctorWho 04/16/24 05:37 AM
Hello everyone,

I ran into a problem when I tried to do:
SELECT * FROM v$session . I get an empty value for the action field, although in fact it is not empty and ACTION HASH is not null.

If I try:
SELECT * FROM sys.v_$session, then everything is displayed correctly.

I noticed that when selecting from v$session, the 'ACTION' field type is varchar2, and when selecting from sys.v_$session type of ACTION field is varchar2(64).

Have anyone encountered this problem? I've already tried changing nls_lang, but it didn't work. The problem does not occur in TOAD.

Using PL/SQL 15.0.4.2064 64 bit,
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Sorry for bad english.
1 80 Read More
PL/SQL Developer Jump to new posts
Re: How to save only package body ? Marco Kalter 04/15/24 09:37 AM
The complete Program Window will be saved, including the package specification and body if both are present in the Program Window. There are 2 solutions:

  • Open the package body and specification in separate Program Windows.
  • Install the "Save separate" Plug-In from the BAR Solutions web site.
1 80 Read More
PL/SQL Developer Jump to new posts
How to save only package body ? mrogel 04/15/24 09:19 AM
Hi,

how do I only save a package body in PL/SQL-Developer ?
For me, it always saves the whole package (header and body) even when I use "Save as type: Package bodies (*.pkb)"

Thanks !
1 80 Read More
PL/SQL Developer Jump to new posts
Re: large DATA Editor - unwanted Tranformation 0D to 0DA in Version 14 and 15 D.Wenzel 04/12/24 12:38 PM
Thanks for the tip Fabrice, I have passed it on to my colleagues.

Have a nice weekend everyone
(too many configuration options are the death of the hare)
2 105 Read More
PL/SQL Developer Jump to new posts
Re: large DATA Editor - unwanted Tranformation 0D to 0DA in Version 14 and 15 fabrice 04/12/24 08:53 AM
In v14, you have in options \ windows types \SQL windows, use LF as CRLF from database.
Perhaps..
2 105 Read More
PL/SQL Developer Jump to new posts
large DATA Editor - unwanted Tranformation 0D to 0DA in Version 14 and 15 D.Wenzel 04/12/24 07:56 AM
Servus Marcus,

SQL Query
select bla, dump(bla) from (select cast('1'||chr(13)||'2' as varchar2(4000)) bla from dual)

bytes - if open the Larg DATA Editor a unwanted, additional CHR(10) 0Ah is added.

Is the a Preference to avoid this?

Ahoi Daniel

... who is proud to have been using PLSQL-Developer for years
2 105 Read More
PL/SQL Developer Jump to new posts
Re: Workset improvement with multiple PSD Cartaz 04/11/24 11:39 AM
Thanks for the reply. I will try that.
And i realised that i can close a workset before closing the PL/SQL Developer. This also prevents "loading last workset" (and probably problem #1).
2 149 Read More
PL/SQL Developer Jump to new posts
Re: Workset improvement with multiple PSD Marco Kalter 04/11/24 08:42 AM
We'll enhance this for the next release.

Note that you might be able to prevent problem #1 by using different PL/SQL Developer shortcuts for different projects/databases. For each shortcut you can use the workset parameter to open a specific workset. For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" workset="Project ABC"
2 149 Read More
PL/SQL Developer Jump to new posts
Workset improvement with multiple PSD Cartaz 04/10/24 11:55 AM
Hi,

i am working with PSD 15.0.4 and i like working with worksets.
As i work with multiple databases and projects, i usually have more than one PSD open (with different worksets).
When i close PSD with a loaded workset and open a new PSD, it wants to load the last closed workset.

This seems to be fine when i boot up windows and open the first PSD but for any additional PSD it should be optional.

Therfore i expirienced the following side effects:
- I get an error message "Error reading file!" when i open a new PSD task, after i deleted the workset which i last worked with (project finished, workset not needed anymore etc.).
- When the database for this workset is not reachable, i get an error message (TNS no listener ...) 3 times for every entry in the window list for this workset! (or i force close the PSD task)

Or ist even possible to prevent this behavior with the actual version?

vg Cartaz
2 149 Read More
PL/SQL Developer Jump to new posts
Re: Version 14 Download Marco Kalter 04/10/24 08:12 AM
The download location is mentioned in your original license e-mail. If you don't have it, please send an e-mail to support@allroundautomations.com with your license serial number for the registered download page.
1 137 Read More
PL/SQL Developer Jump to new posts
Version 14 Download Orlando Dias 04/09/24 06:35 PM
Where can I download 14 version?
1 137 Read More
PL/SQL Developer Jump to new posts
Re: AI support Heiko12345 04/09/24 08:31 AM
:-)
2 155 Read More
PL/SQL Developer Jump to new posts
Re: AI support Marco Kalter 04/09/24 08:28 AM
Yes, we are working on this for version 16.0.
2 155 Read More
Direct Oracle Access Jump to new posts
Re: Check if database if available Marco Kalter 04/09/24 08:27 AM
I have added this to the list of enhancement requests.
3 130 Read More
PL/SQL Developer Jump to new posts
AI support Heiko12345 04/08/24 11:53 AM
Are there efforts to integrate AI support into the PL/SQL developer
2 155 Read More
Direct Oracle Access Jump to new posts
Re: Check if database if available Valgar 04/08/24 10:42 AM
thanks for a quick reply, an idea to implement??
3 130 Read More
Direct Oracle Access Jump to new posts
Re: Check if database if available Marco Kalter 04/08/24 08:44 AM
There is no specific function for this. You would indeed need to attempt to connect and check the result.
3 130 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.158s Queries: 7 (0.060s) Memory: 2.3329 MB (Peak: 2.4004 MB) Data Comp: Off Server Time: 2024-04-25 12:26:39 UTC
Valid HTML 5 and Valid CSS