Problem: Replacing single character with double characters causes infinite loop.
Example:
When I prepare a statement for execute immediate i have to replace single quote with two single quotes.
Input:
select 'a' from dual
Operation:
Replace ' with '' (two quotes)
Expected result (and that I get in Notepad etc):
select ''a'' from dual
What I get in PLD:
select ''a'''''''''''''''''''''''''<loop> from dual
When I hit ReplaceAll - the program hangs up and I have to kill it in Task Manager.
Version: 10.0.2.1697