I don't like to be the bad guy, but enough is enough.
We have reported too many bugs recently and the only thing we hear is "we will check and fix".
It never happen.
The bugs still there and no action has been taken.
I consider the new version a buggy version. I cannot trust what I am doing, because the tool fails too often.
1. copy and paste,
2. beautifier
3. selection of current query
etc.
I hated but I cannot afford to have wrong values because a tool, I am considering switching to Oracle sql developer until this is fixed.
We need a formal answer from allroundautomations when with a date when this will be fixed.
Enough is enough.
Fidel.
1. Copy and paste is fixed in the 64 bit version and will also be fixed in the 32 and 64 bit version of version 12.0.
2. For the beautifier there have been and will be continuous improvements. If you let me know which problem(s) you are experiencing, I will check it out.
3. Can you let me know which problem this refers to?
[quote=Marco Kalter]1. Copy and paste is fixed in the 64 bit version and will also be fixed in the 32 and 64 bit version of version 12.0...[/quote]
I use the 64 bit version (and just upgraded to 11) so I'm not sure how serious the copy/paste problem is exactly, but ... this kind of sounds like you're going to make people pay to get the fix?
[quote=Jeff Kandt]I use the 64 bit version (and just upgraded to 11) so I'm not sure how serious the copy/paste problem is exactly, but ... this kind of sounds like you're going to make people pay to get the fix? [/quote]
We only have a 64 bit version for version 11. It is available to all owners of an 11.0 license without any extra costs.
Problems with copy and paste continue and I have version 11.0.6.1796 64 bit.
It is a mix between copy and paste and selection of current statement.
The sql window allows me to create multiple queries. Let's say 3 different queries.
I have the profile option to autoselect, so I know I have to just place the cursor over the query that I want to execute.
One of those queries is not detected by the autoselect and the previous query keep firing. It shows different results because it is a different query.
I select all 3 queries and click copy, move to another editor and paste. Only the queries that were able to autoselect are copied to the other editor. It could be notepad, textpad, notepad++, and even another editor within pl/sql developer such as "Program window".
If I save the select window, only 2 queries are saved.
It looks like one query is a ghost.
It doesn't happen all the time, but it happens often to create problems.
I also posted several weeks back that the instance list of value (signon prompt when pl/sql developer is just launched) is always empty.
This happen after the 64 bit free version went from beta to production version.
We have a high number of instances and it is hard to remember all the names.
Another bug:
I shutdown my computer every day.
I have the option to auto save my environment, so all the saved programs, sql editor, etch will be the next day.
Some days that doesn't happen, I open a empty pl/slq developer without any program open, even the toolbar defaults to the original (2 rows, instead of 1 like I setup the tool to have it).
The next day, it goes back as I had it. All the programs open the very next day and the toolbar goes back how I set up.
I don't change the toolbar every time, because I know the next day it will come back how I had it.
It acts random, and I cannot predict when this will happen.
If I try to sign in using a new instance (relaunching the tool), sometimes it asks me for the password for the new instance, then the sign on goes gray.
Then it comes back with the original instance (not the one that I am trying to connect) and asks me for the password.
So I know I won't be able to connect to the new instance. I have to log in, then I know I have to change the instance in each window.
This doesn't happen every day, it happens random.
Some days it goes straight to instance that I am trying to connect.
When this happen it goes together with the problem with a new empty environment and toolbar switched to the default from pl/sql developer.
I have so many other issues, that I will create a long list and I will paste it here.
I have to be vigilant to know where the tool is taking me, because I don't trust it. I could provide values from different queries or different instances. It is a big problem.
Have you considered downgrading or switching to the 32-bit client?
I use PLD 11.0.6 x64 rather heavily but I never met the problems that you described.
There's has to be something with you environment.
@IvanZ I thought so, but I am not the only one with those problems.
Not everyone has them, but they have been reported and some people share them.
I am in USA and some are in Europe different companies, so we are spread far enough to discard any local environment.
These a list of some bugs reported by me or I have participated.
-- Version 11: Copy and Paste Doesn't Work. Help Please
-- The database list on the logon screen is always empty
-- Getting (Not Logged on)
-- Copy&Paste/Syntax Hihlighting Bug
They have not been resolved by Allroundaoutomations, only they have not been followed up by them.
There are more issues like those, that I have not posted or commented. I shared some others people issues, but I haven't commented.
Fidel
Since I switched to the 64bit version, all of my copy and paste problems went away. If you still have problems, check whether you have "clipboard monitor"-type programs running, or have Microsoft Office open since it also likes to monitor the clipboard.
The login screen may be empty because your tnsnames.ora is empty? Be aware that the 32bit version and 64bit version use different Oracle Clients and so use different paths. Opening "Help->Support Info" from the PLD menu can be very helpful in figuring this out.
If you have any problems that you can reproduce with a fixed number of steps ("open PLD", "click here", "type this") then post it here and many other users will try to reproduce the problem as well. If that happens there's a great chance the bug will get fixed.
I do agree that "Allroundautomations" has a poor track record of responding to forum posts here, especially once threads get longer than a comment or two. However I just assume that any time they're not posting comments they're actually working on fixing bugs. And I'd rather have them fix bugs.
This is one example of my problem. It takes me some time to figure out why is happening. I waste too much time.
I have a sql editor with the following:
SELECT * FROM ap_Invoice_Payments_All WHERE invoice_id = 3805895 AND check_id = 2210149; AT least I think I have that.
I run it and gives an error: missing expression.
I spend time looking at the syntax and scratching my head.
Then I decided to select all that sentence and copy and a editor (notepad ++).
When I paste this is the result:
SELECT * FROM ap_Invoice_Payments_All WHERE invoice_id = 3805895 AND check_id =
See I am missing the check id value of 2210149 and the semicolon.
I am able to see them in the editor, but PL/SQL developer ignores that. It is like is a ghost.
Sometimes I paste those values from the application into the editor, to me the common denominator is the copy/paste.
I agree it is a part windows problem, but it should be a way to prevent from the tool, patch or something. At least don't allow copy and paste outside the tool so that way (it will be more difficult for everyone) we know the limitation.
I wasted time to figure out that one.
Now if I save the sql editor I will miss some values.
I have to close that sql editor, because even if I remove the part that is being ignored and typed it myself. The problem continues.
So that editor is useless, I have to close it and open a new editor and start over.
It is frustrating.
That sounds suspiciously as if some extra hidden character (nul? eof? utf-8 broken garbage?) exists after "check_id =".
Did you copy the value "2210149" from another application before pasting it? If so, what was that application?
Next time it happens, try deleting and manually re-typing "id = 22" to see if that fixes the problem. If so, that would get us closer to figuring out the cause.
EDIT: sorry just noticed "even if I remove the part that is being ignored and typed it myself. The problem continues." That would drive me crazy too. Please do try also replacing the "id = " part that isn't being ignored, just in case there is something hidden at the end of it.
The applications is Oracle applications Payables.
I will try removing more when this happen again and I will report.
11.0.4.1788 x64, I always manually highlight the exact query in SQL window to execute and haven't encountered your problem.
Are you using some other feature that auto highlights a block of query to execute? (I am not familiar with this)
PL/SQL developer has an option (setup) to autoselect the queries.
It is based on ";" and plsql blocks.
If you have that setup and have multiple queries you need to only place the cursor in top of the query you want to execute (not highlight the entire query).
It will execute only that query (or at least that is what is intended for).
Menu: Tools >> Preferences >> Window Types >> SQL Window >> Click on AutoSelect statement.
Hi,
I also have problom with AutoSelect statement. Sometimes it doesn't work - as it was mentioned by fidelfs in some threads. It's really annoying.
Problem appears even when statements are diveded with ";" - or wiht "/".
To me, mostly it happens, when I have in one of statements ORDER BY clause. So, this is maybe hint for AllroundAutomations to debbug...