Toad World® Forums

Problem with Toad DBA Suite for Oracle 12.1 64-bit Commercial

After installation of Toad DBA Suite for Oracle 12.1 I encountered following problem:

When executing query from Editor with command ‘Execute as script’ there are problems with wrapping of multiline text.

The new behavior is unexpected and different from previous versions of TOAD.

The problem also occurs when running script with ‘Quest script runner’, but not with SQL*Plus.

Text is correctly displayed in ‘Grid popup Editor’

Example:

set feedback off

set pages 0

set lines 78

select ‘1234567890123456789012345678901234567890’

   || chr (10)

   || '1234567890123456789012345678901234567890'

   || chr (10)

   || '1234567890123456789012345678901234567890'

   || chr (10)

from dual;

Result in Toad 12.1:

1234567890123456789012345678901234567890

1234567890123456789012345678901234567

890

1234567890123456789012345678901234567890

Result in Toad 12.0

1234567890123456789012345678901234567890

1234567890123456789012345678901234567890

1234567890123456789012345678901234567890

Thank you and best regards!

Thanks for the example…I’ll take a look and see what the issue is.

Greg

From: Aci Polajnar [mailto:bounce-acip_296@toadworld.com]

Sent: Monday, October 21, 2013 6:20 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Problem with Toad DBA Suite for Oracle 12.1 64-bit Commercial

Problem with Toad DBA Suite for Oracle 12.1 64-bit Commercial

Thread created by Aci Polajnar

After installation of Toad DBA Suite for Oracle 12.1 I encountered following problem:

When executing query from Editor with command ‘Execute as script’ there are problems with wrapping of multiline text.

The new behavior is unexpected and different from previous versions of TOAD.

The problem also occurs when running script with ‘Quest script runner’, but not with SQL*Plus.

Text is correctly displayed in ‘Grid popup Editor’

Example:

set feedback off

set pages 0

set lines 78

select ‘1234567890123456789012345678901234567890’

  || chr (10)



  || '1234567890123456789012345678901234567890'



  || chr (10)



  || '1234567890123456789012345678901234567890'



  || chr (10)

from dual;

Result in Toad 12.1:

1234567890123456789012345678901234567890

1234567890123456789012345678901234567

890

1234567890123456789012345678901234567890

Result in Toad 12.0

1234567890123456789012345678901234567890

1234567890123456789012345678901234567890

1234567890123456789012345678901234567890

Thank you and best regards!

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.

if you execute as script then linesize is active.

So for test set this command before:

set linesize 200;

and execute your script again.

Brg

Damir Vadas

Thank you Damir for your response but the main question was,

why my original script with “set lines 78” runs fine with TOAD 12.0.

Also it runs fine with SQL*Plus

Regards!

Hello Gregory!

Do we have any progress on this issue ??

Regards!

This is fixed in the current 12.5 beta.

Greg

On Nov 7, 2013, at 4:46 AM, “Aci Polajnar” bounce-acip_296@toadworld.com wrote:

RE: Problem with Toad DBA Suite for Oracle 12.1 64-bit Commercial

Reply by Aci Polajnar
Hello Gregory!

Do we have any progress on this issue ??

Regards!

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.

Hi,

I installed Toad 12.6.0.53 and the problem is stil not fixed.

There is another problem:

When I set linesize long enough (as Damir Vadas suggested) then the last line of text is repeated.

Example:

set feedback off

set pages 0

set lines 2000

select ‘1.line :1234567890123456789012345678901234567890’|| chr (10)

|| ‘2.line :1234567890123456789012345678901234567890’|| chr (10)

|| ‘3.line :1234567890123456789012345678901234567890’

from dual;

Result:

1.line :1234567890123456789012345678901234567890

2.line :1234567890123456789012345678901234567890

3.line :1234567890123456789012345678901234567890

3.line :1234567890123456789012345678901234567890

Best regards

Gorazd

Hi
Gorazd - thanks for reporting this - I have logged it as a bug for the developer.

From: gorazd.divjak [mailto:bounce-gorazddivjak@toadworld.com]

Sent: Thursday, December 11, 2014 4:17 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Problem with Toad DBA Suite for Oracle 12.1 64-bit Commercial

RE: Problem with Toad DBA Suite for Oracle 12.1 64-bit Commercial

Reply by gorazd.divjak

Hi,

I installed Toad 12.6.0.53 and the problem is stil not fixed.

There is another problem:

When I set linesize long enough (as Damir Vadas suggested) then the last line of text is repeated.

Example:

set feedback off

set pages 0

set lines 2000

select ‘1.line :1234567890123456789012345678901234567890’|| chr (10)

 || '2.line   :1234567890123456789012345678901234567890'|| chr (10)

 || '3.line   :1234567890123456789012345678901234567890'

from dual;

Result:

1.line :1234567890123456789012345678901234567890

2.line :1234567890123456789012345678901234567890

3.line :1234567890123456789012345678901234567890

3.line :1234567890123456789012345678901234567890

Best regards

Gorazd

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.