Active Threads | Active Posts | Unanswered Today | Since Yesterday | This Week
PL/SQL Developer Jump to new posts
Re: New Design/Layout -> Colored Icons stefanz 02/24/24 05:30 PM
Despite having a license for version 15 I still use 14, want to guess why?
15 2,297 Read More
PL/SQL Developer Jump to new posts
Error Message in Sessions > SQL Monitor zstringer 02/23/24 02:47 PM
Hi all,
Suffering significant slowdowns of a PL/SQL process that used to be faster. Tables and indexes are analyzed on a daily basis. When I look at a problematic SQL statement in Tools > Sessions, when I click on SQL Monitor I get these errors:

ORA-31011: XML parsing failed
ORA-06512: at "SYS.DBMS_SQLTUNE", line 18940
ORA-19213: error occurred in XML processing at lines 1
LPX-00242: invalid use of ampersand ('&') character (use &)
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQLTUNE", line 14318
ORA-06512: at "SYS.DBMS_SQLTUNE", line 19036
ORA-06512: at "SYS.DBMS_SQLTUNE", line 19367
ORA-06512: at line


Has anyone seen this?
Thanks!
-Peter
0 22 Read More
PL/SQL Developer Jump to new posts
Re: Oracle Cloud Login Issues dgs! 02/20/24 09:42 PM
thx
3 422 Read More
PL/SQL Developer Jump to new posts
Re: problems connecting to the db on pl/sql developer gremonesi 02/20/24 07:15 PM
place the system in a directory whose name does not have a space, for example:
C:\Program Files
Place
C:\ProgramFiles
2 132 Read More
PL/SQL Developer Jump to new posts
Re: "A TLOBLocator instance requires OCI8 mode, but OCI7 mode is used" on query using Oracle 21c Marco Kalter 02/20/24 09:58 AM
For Oracle21c support you will need to upgrade to PL/SQL Developer 14.0.6 or later.
1 61 Read More
PL/SQL Developer Jump to new posts
Re: PL/SQL Developer why not support for Mac OS X? Marco Kalter 02/19/24 09:29 AM
We're working on a new cross-platform PL/SQL Development tool for MacOS, Linux, and Windows: Plyxon. It is currently in beta.
15 31,635 Read More
Direct Oracle Access Jump to new posts
Re: Memory leak when TOracleConnection.StatementCache=true gc@siospa.it 02/16/24 01:18 PM
Another strange behavior of the component is that doesn't leak if the CacheSize property of the session is below the number of different queries to execute.
For example, if the application periodically does 10 different queries and the CacheSize is set to 9 there is no memory spill.
But this configuration is useless because the queries are periodically re-parsed again by the database.
3 124 Read More
PL/SQL Developer Jump to new posts
Re: HELP! Trying to connect to Oracle XE Marco Kalter 02/13/24 10:02 AM
What exactly goes wrong? Are there any error messages?
1 111 Read More
PL/SQL Developer Jump to new posts
Re: GIT Integration raam94 02/12/24 03:36 PM
I have correctly configured the PL/SQL and GitLab through the use of GitExtension.
But now, I have to bring the entire DB on the Repository, is there a feature that exports the structure of DB (such us Table : table1, table 2..., Procedure: proc1, proc2..) and allow me to import that in File section for repository? Or do I have to do all manually?

Thank you very much
4 345 Read More
PL/SQL Developer Jump to new posts
Re: Export to Excel set default Author Mew 02/09/24 11:52 AM
Ok. Thanks!
2 122 Read More
PL/SQL Developer Jump to new posts
Re: Best way to deal with XML RickS 02/08/24 04:36 PM
I have noticed something new. When the "Edit column data externally as XML File?" prompt comes up, if I click "No" and I have the padlock unlocked, I am able to edit XML in PL/SQL Developer's Large Data Editor. I didn't realize that. I thought that the native editor was read-only and I needed to install another tool - like Notepad++ in order to edit XML.

My goal is just to be able to edit data. I don't care what editor I use. If I can do that within PL/SQL Developer's Large Data Editor then I don't need to configure Notepad++ at all.

When I query my data, it does make me select the rowid from the table in order to edit and save XML, which is kind of a pain, but I can live with that.
21 1,620 Read More
PL/SQL Developer Jump to new posts
Re: Cannot scroll while query in progress Marco Kalter 02/08/24 10:57 AM
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, including the cancel button issue, 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).
6 817 Read More
PL/SQL Developer Jump to new posts
Re: Is PL/SQL Developer available for MAC fabrice 02/08/24 08:29 AM
no, look for plyxon, the team works on a new software, linux, macos and windows compatible.
You can download the beta version.

Plyxon
1 105 Read More
PL/SQL Developer Jump to new posts
Re: Window flickering when sharing on Skype Marco Kalter 02/06/24 10:12 AM
We'll check it out.
1 94 Read More
PL/SQL Developer Jump to new posts
Re: Use schema name when saving object DDL Marco Kalter 02/06/24 10:12 AM
There is currently no option for this. I have added this to the list of enhancement requests.
1 86 Read More
Direct Oracle Access Jump to new posts
Re: How to define a timeout to a TOracleQuery? Marco Kalter 02/06/24 09:52 AM
The TOracleQuery or TOracleSession do indeed not have any property or method for this. You would need to run the query in a background thread and call TOracleSession.BreakExecution from the main thread if the query needs to be cancelled.
1 96 Read More
PL/SQL Developer Jump to new posts
Re: Autocomplete does not see all DBA objects stefanz 02/05/24 09:28 PM
well, if the user really has SELECT ANY DICTIONARY as written above, then yes, he has select priviliges on dba_views
i

for me a similar issue has not worked for several releases now. as a workaround, I use the commandline switch "oldnameresolve", maybe this also helps
https://forums.allroundautomations....oldnameresolve&Search=true#Post47053
2 141 Read More
PL/SQL Developer Jump to new posts
Re: DBMS_DEBUG Daniel Viero 02/05/24 02:38 PM
Feedback: our problem with DBMS_DEBUG was related to RAC setup. We've solved the issue by following this post: https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=56852#Post56852.
Thanks.
6 1,407 Read More
PL/SQL Developer Jump to new posts
Re: Compare User Objects Invalid index Marco Kalter 02/02/24 10:19 AM
It should be fixed. Can you send the plsqldev.elf file of the error message to support@allroundautomations.com?
4 1,881 Read More
PL/SQL Developer Jump to new posts
Re: Two bugs: Access violation and ORA-00918 Marco Kalter 02/02/24 10:13 AM
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 "ORA-00918: column ambiguously defined" 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).
3 278 Read More
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.024s Queries: 6 (0.009s) Memory: 2.2159 MB (Peak: 2.3272 MB) Data Comp: Off Server Time: 2024-02-25 10:43:11 UTC
Valid HTML 5 and Valid CSS