Problem with beautifier

[tfferreira]

Hi,

I'm having a problem with beautifier when using '||' version (7.1)

If I use a statement (inside a package) like the one showed below :

OPEN <cursor> FOR 'select * ' || ' from table ' || ' ' where  ... '

the lines are not being breaked.

If we have a select with more than 2499 characters this package will not be compiled in sqlplus, it will give a SP02-0027 error.

Am I missing something in beautifier configurations ?

 

[braykov]

I think not.
Actually I reported about this on the Beta forum.
I suggested two methods for beautifying concatenations. I hope they've implemented it in 7.1 Final. I haven't installed it yet.

 

[mike]

Setting the right margin in the beautifier works for me. It's still UGLY and hard to read, but it tries to keep the line length within the margin at least.

Mike