I am not allowed to give you the full code, but I have narrowed it down to a small function which still fires the error. Try it:
FUNCTION My_FUNCTION( p NUMBER ) RETURN NUMBER IS
BEGIN
IF FALSE IS NULL
THEN
IF TRUE
THEN
SELECT...
We get an error trying to beatify the following:
SELECT XMLQuery('copy $d := $se
modify (
for $i in $d/PmtInf/DrctDbtTxInf/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/AmdmntInfDtls/OrgnlCdtrSchmeId/Id/PrvtId/Othr/SchemeNm
return...
UPDATE:
I just noticed a pattern: the quantity of whitespace entered on empty lines is equal to the number of indentations on the line just above it minus one.
So if the above line is indented 3 times with 3 tabs, the following line would have 2 tabs.
Or if spaces are used and the indentation is...
The Beautifier has 3 options for "Empty lines". When I set it to "Remove" (which should collapse all empty lines) and I try to beautify the following code:
CREATE OR REPLACE PACKAGE BODY my_package IS
var1 VARCHAR2;
var2 INTEGER;
var3 CLOB;
BEGIN
RETURN;
END my_PACKAGE;
The result is...
I am not upset by you :-)
I am actually upset by the software and by the fact that we pay money for licenses for years. And I have voted for my team to use this software and I have also influenced on using it in the previous company I worked for.
And there are bugs there standing un-fixed for...
Beautifying the code to a common style is a MUST for us now. One way or another, we are going to do it.
I intend to force the option to automatically apply the beautifier before compile for all developers.
I have recently found there were more bugs with this feature than I expected and I am...
Everyone, please, stop suggesting complex workarounds. This is a bug and I need it fixed. There are a lot of bugs with this functionality and i have about 600 Oracle object files that need beautifying and it is not just the views.
The beautifier fails on types like the following:
CREATE OR REPLACE TYPE "SCHEMA_NAME"."MY_VALUES_ARRAY" IS VARRAY (100) OF my_values;
/
CREATE OR REPLACE TYPE "SCHEMA_NAME"."MY_TBL_T" as table of MY_REC_T;
/
Also files formatted with BEAUT command get emtpied.