Quoted string (10g) causes error in beautifier

[Franc van Berkel]

When I use the 10g quoted strings option the beautifier causes an error.

Example:

begin
htp.p(q'~tbertb'rtb'ertber'tbe
dfgsd'fgsd'fgsd'fgsdfg'
rtb~');
end;

It seems it occurs especially when the string is on multiple lines.

Regards,
Franc.

 

[Marco Kalter]

That's indeed not right. We'll fix it.

 

[ID20]

Hi Marco,

we have the same problem, even when the string is on one line.
The beautifier breaks

a_string||q'[t.changeuser = 'XYZ']'||a_string

into three lines:

a_string|| q
'[t.changeuser = ' XYZ
']' ||a_string

and therefore the package is no longer valid )-:

What do you think when this will be fixed?

Regards
Andreas

 

[Marco Kalter]

We will include this fix in 7.1.

 

[Scott Eli]

Was this fix included in 7.1?

 

[Marco Kalter]

The 2nd error should be fixed. For multi-line strings we do not yet have a solution.