Running PL/SQL Dev version 5.1.5.744.
Here's my problem. I have a 500 line package body which has the following code somewhere in the middle:
INSERT INTO item_cost_tmp
SELECT blah1, blah2, blah3...blah33
FROM dual;
The SELECT line is very long, 300 characters long to be exact. On the editor it's all in one line (no wrap).
I can compile this package body and run it with no problems. However, when I open it again to make editing changes, the SELECT line has now wrapped around and looks like this:
SELECT blah1, blah2, blah3...blah20
blah21, blah22...blah33
It cuts off at 255 chars and wraps the rest to the next line. I have to remember to correct this before recompiling the package otherwise my data gets all screwed up.
I can't find anywhere a setting that allows me to change the editor linesize so that this wrapping doesn't take place.
Any ideas would be so greatly appreciated!!!
Manny
Here's my problem. I have a 500 line package body which has the following code somewhere in the middle:
INSERT INTO item_cost_tmp
SELECT blah1, blah2, blah3...blah33
FROM dual;
The SELECT line is very long, 300 characters long to be exact. On the editor it's all in one line (no wrap).
I can compile this package body and run it with no problems. However, when I open it again to make editing changes, the SELECT line has now wrapped around and looks like this:
SELECT blah1, blah2, blah3...blah20
blah21, blah22...blah33
It cuts off at 255 chars and wraps the rest to the next line. I have to remember to correct this before recompiling the package otherwise my data gets all screwed up.
I can't find anywhere a setting that allows me to change the editor linesize so that this wrapping doesn't take place.
Any ideas would be so greatly appreciated!!!
Manny
