Formatting Issue

Toad for Oracle & DevOps Toolkit
1

I have just installed Toad for Oracle version 10.1.1.8 and have noticed some formatting issues. For example, the following does not format with the multi-line comment in place:

declare
procedure test_proc is begin
begin

for io_cursor in (select * from DUAL)
loop
if 1=1 then
NULL;
end if;
/*
multi line comment
this line will cause the formatter not to format properly
*/
end loop;

commit;
end;

exception
when others then
rollback;
end test_proc;
begin
null;
end;

If the comment is removed, this is the result:

DECLARE
PROCEDURE test_proc
IS
BEGIN
BEGIN
FOR io_cursor IN ( SELECT * FROM DUAL )
LOOP
IF 1 = 1
THEN
NULL;
END IF;
END LOOP;

     COMMIT;
  END;

EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
END test_proc;
BEGIN
NULL;
END;

Does anybody have a fix or suggestions towards a fix?

2

Kelly,

This issues has been discussed before, see
http://tech.groups.yahoo.com/group/toad/message/49964 .

Thanks,

Andre

3

Just to sum things up, I downloaded the Toad for Oracle 10.5 beta and installed it. I first, renamed the QP5.dll in the commercial folder. I then moved the QP5.dll from the beta folder to the commercial folder. Formatting now works. The odd thing is, is that the commercial version is QP5 v5.139.911.3011 and the beta version is QP5 v5.136.908.31019. This is not the same version mentioned in the thread of the above link, but it does format the code.

4

Kelly, where did you get the beta from? It looks like you grabbed an older
beta. As far as I know the beta has QP5 v5.144. Did you update it using
http://www.toadfororacle.com/beta.jspa ?

Andre

5

Yes, I used that link to get the install. Maybe I should try again.