Recent content by juanian

Sadly, it appears that this will never be fixed. I recently upgraded to Version 14 and just ran into the problem (again). Checking the forums, I still see my original post from 13 years ago ( Debug session 'stuck' on ORA-03114 - not connected to oracle loop ). The problem can occur when a...

When using the Explain Plan window, right-clicking on the plan details shows a 'Copy' command, which copies the plan details to the clipboard as tab-delimited text. Can a second option be part of the right-click that is "Copy with Header" (like there is when right-clicking on a SQL Window...

And it has been around for quite a while . . . Debug session 'stuck' on ORA-03114 - not connected to oracle loop

This problem has existed for a very long time, and I (like you) didn't realize that the auto-recovery didn't retain the last saved file contents. Every time I recover from a crash, I always compare all windows (with the last saved version of the file) to see what has changed, and close all open...

I've had a similar problem. Check your TNS definition - if it has something like "(RETRIES = 180)(DELAY = 5)", it can be contributing to your issue. (Why Oracle seems to like "RETRIES = 180" is beyond me; this causes programs (like PL/SQL Developer) to retry 180 times (with a delay of 5...

I have a similar problem, but I don't think the workaround from archer works for me. When I try to close the window, I get the "Test Window can't be closed..." box. Clicking Terminate give me the error: Error during debug step: ORA-03114: not connected to ORACLE Debug session terminated. but...

(Sorry for the late reply - this wasn't in my Watched Topics) Dates that are formatted with the 12-hour time don't show the AM (or PM) properly when using "Copy to Excel"/"Copy all as xls" - it appears like A1P1, or A4P4, or A10P10, or ... . The fix that was made for the "Copy to Excel"/"Copy...

Has anything been found related to this issue? It has plagued me since version 7 (and I am now using 9). What I have seen is the following: After clicking Import, the cursor turns into a spinning circle (Windows 7/64-bit), and the number of imported records increments in the status bar. After...

Also, in addition to showing a log of errors encountered, how about an ability to log duplicates? I've performed an import, and there are duplicate records, but I don't know which records are duplicates. (Maybe adding a third radio button "Flag duplicates" to allow the duplicates to be logged...

I've had that problem happening since version 7. I've seen that sometimes, if PL/SQL Developer is busy doing certain actions, the window becomes "invisible" to mouse clicks, and whatever window is behind PSD will get the mouse click. It is mildly annoying, but I've just learned to live with it...

I am seeing the AM/PM problem (A7P7) with 9.0.6.1665 when I use "Copy to Excel" / "Copy all as xls". The other 3 copy to Excel methods work fine.

One other note: If the tnsnames.ora file has multiple entries with the same TNS name, the list may not display in the Database dropdown (at least that is what I have seen with version 7.1.5.1398)

If you are on a PC connected to an Oracle server, one other possibility (to regain control over PL/SQL Developer) is to unhook your ethernet connection, wait a few seconds (for your connection to time out), then reconnect your computer to the network. In some cases, this might not kill the...

Does anyone know if this was fixed in 7.1.5? (It is not listed as one of the enhancements for 7.1.5, so I'm assuming it was not.) I'm currently using a stable version of 7.1.4.1390, and I'd rather wait until an update fixes/has something I'd like before I upgrade.

Odd - I've always noticed that behavior. If I have an error in a package that has a line displayed with a yellow hightlight, copying lines (that include the yellow highlighted line) and pasting the lines somewhere else always has an extra blank line added after the highlighted line. (Current...