Toad World® Forums

TOAD FREEWARE VERSION 12.9

We found two problems in this new version:

  • In the connection. If you choive DIRECT, the options not save correctly. It save like TNS and with service name (if SID is not equal SERVICE, one error occurs).

  • If you need change any procedure/function using editor. If the procedure/function have lines empty, one message is displayed(invalid caracter). It is necessary delete some empty lines.

The Direct Connection problem should be fixed in 12.10, which will be released soon.

I’m not sure about the Editor problem, but make sure it ends with a semicolon after the final END and a slash on a new line after that.

When I make a procedure/function changes using version 12.8, it´s work fine.

I tried the same operation using version 12.9 and one message is displayed (invalid character) and I cant compile. Then, I remove blank line on the beginning of procedure/function and the message disappear.

De: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Enviada em: sexta-feira, 16 de setembro de 2016 10:52
Para: toadoracle@toadworld.com
Assunto: RE: [Toad for Oracle - Discussion Forum] TOAD FREEWARE VERSION 12.9

RE: TOAD FREEWARE VERSION 12.9

Reply by John Dorlon

The Direct Connection problem should be fixed in 12.10, which will be released soon.

I’m not sure about the Editor problem, but make sure it ends with a semicolon after the final END and a slash on a new line after that.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

There’s a new option to treat blank line as statement terminator. Disable the option on the “Execute/Compile” page in Options.

Can you post sample PL/SQL that reproduces it? PL/SQL should be exempt from the option, but there have been some cases that have come up as you describe. We’d like to fix them so an example would be much appreciated.

Thanks,

Michael

I had to remove all blank lines in my scripts from 12.8 to 12.9 also. Pain!

Mark Fringer

Nokia (ALU) Core

708-240-7598 - LYNC Number

815-715-8048 - Cell Number

This email and any files transmitted with it are AT&T property, are

confidential, and are intended solely for the use of the individual or

entity to whom this email is addressed. If you are not one of the named

recipient(s) or otherwise have reason to believe that you have received

this message in error, please notify the sender and delete this message

immediately from your computer. Any other use, retention,

dissemination, forwarding, printing or copying of this email is strictly

prohibited.

From: adihorie [mailto:bounce-adihorie@toadworld.com]

Sent: Friday, September 16, 2016 9:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] TOAD FREEWARE VERSION 12.9

RE: TOAD FREEWARE VERSION 12.9

Reply by adihorie

When I make a procedure/function changes using version 12.8, it´s work fine.

I tried the same operation using version 12.9 and one message is displayed (invalid character) and I cant compile. Then, I remove blank line on the beginning of procedure/function and the message disappear.

De: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Enviada em: sexta-feira, 16 de setembro de 2016 10:52

Para: toadoracle@toadworld.com

Assunto: RE: [Toad for Oracle - Discussion Forum] TOAD FREEWARE VERSION 12.9

RE: TOAD FREEWARE VERSION 12.9

Reply by John Dorlon

The Direct Connection problem should be fixed in 12.10, which will be released soon.

I’m not sure about the Editor problem, but make sure it ends with a semicolon after the final END and a slash on a new line after that.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

The option noted will resolve it if unchecked. Generally speaking the experience should be nearly seamless for most users upgrading to 12.9. However, I have seen some sample SQL that contains blank lines within a single statement. Users coding in this style will need to either code differently or uncheck that option. If blank lines in PL/SQL are creating problems then this is a bug. Please report cases here along with a code sample that demonstrates the issue.

Thanks,

Michael

Ok. I have a meeting now. I will send to you later…

De: Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]
Enviada em: sexta-feira, 16 de setembro de 2016 11:12
Para: toadoracle@toadworld.com
Assunto: RE: [Toad for Oracle - Discussion Forum] TOAD FREEWARE VERSION 12.9

RE: TOAD FREEWARE VERSION 12.9

Reply by Michael Staszewski

There’s a new option to treat blank line as statement terminator. Disable the option on the “Execute/Compile” page in Options.

Can you post sample PL/SQL that reproduces it? PL/SQL should be exempt from the option, but there have been some cases that have come up as you describe. We’d like to fix them so an example would be much appreciated.

Thanks,

Michael

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

Dear Michael

I unckeck de option above and now the editor work fine!

Thanks for your help.

I will wait for the new version 12.10

Adalberto

De: Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]
Enviada em: sexta-feira, 16 de setembro de 2016 11:12
Para: toadoracle@toadworld.com
Assunto: RE: [Toad for Oracle - Discussion Forum] TOAD FREEWARE VERSION 12.9

RE: TOAD FREEWARE VERSION 12.9

Reply by Michael Staszewski

There’s a new option to treat blank line as statement terminator. Disable the option on the “Execute/Compile” page in Options.

Can you post sample PL/SQL that reproduces it? PL/SQL should be exempt from the option, but there have been some cases that have come up as you describe. We’d like to fix them so an example would be much appreciated.

Thanks,

Michael

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

Can you provide sample code that demonstrates the problem you were seeing? 12.10 is wrapping up now so you may notice no changes here and without knowing what the issue is we can’t fix it.

On Sep 16, 2016, at 5:44 PM, adihorie bounce-adihorie@toadworld.com wrote:

RE: TOAD FREEWARE VERSION 12.9

Reply by adihorie
Dear Michael

I unckeck de option above and now the editor work fine!

Thanks for your help.

I will wait for the new version 12.10

Adalberto

De: Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]

Enviada em: sexta-feira, 16 de setembro de 2016 11:12

Para: toadoracle@toadworld.com

Assunto: RE: [Toad for Oracle - Discussion Forum] TOAD FREEWARE VERSION 12.9

RE: TOAD FREEWARE VERSION 12.9

Reply by Michael Staszewski

There’s a new option to treat blank line as statement terminator. Disable the option on the “Execute/Compile” page in Options.

Can you post sample PL/SQL that reproduces it? PL/SQL should be exempt from the option, but there have been some cases that have come up as you describe. We’d like to fix them so an example would be much appreciated.

Thanks,

Michael

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.