Why I got the following beautifier message?

[fidelfs]

PL/SQL Beautifier could not parse text!

Why is that? It is a pl/sql code.

 

[Marco Kalter]

The error message indicates that the PL/SQL Beautifier could not parse the PL/SQL code. This indicates that there might be some basic error (e.g. missing parenthesis, missing END, and so on).

If this is not the case, can you send the complete PL/SQL text to support@allroundautomations.com ?

------------------
Marco Kalter
Allround Automations

 

[rbrooker]

it would be a cool idea to have an error message that displayed where in the code the beautifier got to, or where it found an error. that would help in finding missing brackets etc.

cheers.

------------------
richard.brooker@vuw.ac.nz

 

[Marco Kalter]

You can compile the code to find an accurate error position.

At this moment the parser of the PL/SQL Beautifier is not very strict when checking the syntax, and as a result it is not able to provide a very accurate error position.

------------------
Marco Kalter
Allround Automations

 

[dom999v]

I get the same message ('could not parse text') when I try to use the Beautifier on the following code

select sysdate from dual;

Not sure why, any clues?

 

[Marco Kalter]

I can't reproduce this. Are you using a SQL Window, Test Window, or Program Window?

------------------
Marco Kalter
Allround Automations

 

[fidelfs]

I found the problem.

If your code is not between BEGIN and END, beautifier is not able to parse the code.

I try this and did not work:
Column Dummy Format a(5);

SELECT Dummy FROM Dual;
I was using command window.

I put BEGIN and END and did it work as a charmed.

BEGIN
Column Dummy Format a(5);

SELECT Dummy FROM Dual;

END;

Regards.

 

[dom999v]

Thanks for the reply.

It was in an SQL window. I tried as suggested to surround it with begin and end but that didn't make any difference (although I would have thought this was un-necessary anyway - what if you want to format SQL as oppose to PL/SQL).

 

[fidelfs]

You are right Beautifier works only for PL/SQL.

what I was trying to point out is a work around while allround fix the problem.

The only time the begin and end did not work was with sqlplus code like "column c1 format a30"

I tried on sql window, command window , etc and always works except for sqlplus commands.