Print Thread
Replace infinite loop
#47066 05/14/13 01:12 AM
Joined: Feb 2013
Posts: 251
UTC+10
I
IvanZ Offline OP
Member
OP Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
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

Re: Replace infinite loop
IvanZ #47070 05/14/13 09:33 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
We'll fix it.


Marco Kalter
Allround Automations
Re: Replace infinite loop
Marco Kalter #47074 05/15/13 07:58 PM
Joined: Sep 2004
Posts: 111
USA
I
Member
Offline
Member
I
Joined: Sep 2004
Posts: 111
USA
This is still an issue in PL/SQL Developer version 10.0.3.1701

Re: Replace infinite loop
Ivan C. #47079 05/16/13 10:02 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
Correct. This will be fixed for the next patch release.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.078s Queries: 14 (0.007s) Memory: 2.5072 MB (Peak: 3.0417 MB) Data Comp: Off Server Time: 2024-05-20 16:22:50 UTC
Valid HTML 5 and Valid CSS