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...