Formatter rejecting valid code.

Toad for Oracle
1

Since I upgraded to 12.8 (which I mostly love) Toad is now giving an error every time I format some of our packages.

In the example below:

declare
subtype t_long_string is varchar2( 32767 );

v_string t_long_string;
begin
v_string := ‘a’;
end;
/

It complains that about the line “v_string t_long_string;” saying “Found ‘t_long_string’: This variable has a zero size”

It still does the formatting and can execute the code.

Thanks

Dan

2

Dan,

You may want to have a look at www.toadworld.com/…/57077, and other similar threads.

A workaround for now is to avoid the words “string”, “varchar” and perhaps a few others as part of your variable name.

Andre

3

Thanks.

Unfortunately it’s not really practical to run around changing our datatypes so I’ll just have to live with it - or go back to using 12.7 if it gets too irritating.

4

You could install the beta and grab the QP5.dll from it and use in your 12.8 installation. Backup the original first so you can restore it if needed.

Michael

On 11/16/2015 04:24 AM, DanCJ wrote:

RE: Formatter rejecting valid code.

Reply by DanCJ
Thanks.

Unfortunately it's not really practical to run around changing our datatypes so I'll just have to live with it - or go back to using 12.7 if it gets too irritating.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

5

That’s worked perfectly - Thanks!