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
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:
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
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.