Toad World® Forums

multiline sql output truncated


#1

Hi

As the title said. 12.5.0.46

Regards

Laurent

PS: sorry, this was supposed to be posted in the Beta Discussion Forum

SQL> select ‘1’|| chr(10) || ‘2’|| chr(10) || ‘3’ from dual

‘1’||CHR(10)||‘2’||CHR(10)||‘3’


1

1 row selected.


#2

It is not … I tested on latest beta as well as latest regular toad-all works perfect.

click on dots represented in point “2” and you’ll get content i point “3”

If you press F5 (run as script) output is OK again:

And your output is from where … seems a little bit strange that this come from toad…

:slight_smile:

Brg

Damir


#3

Ah yes, I can see this happening in the beta. I will create a CR for this. Thanks for reporting it.


#4

@Denis,
Here is mine picture once more.
Could you please tell me what is wrong here? What am I missing?
Brg
Damir


#5

yeah - that’s the GA version. I noticed that there was an update to the post (that didn’t come thru email) that said it was supposed to be posted to the
beta forum. When running this with F5 in the beta, it only shows the first number in the output.

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Monday, March 24, 2014 1:00 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] multiline sql output truncated

RE: multiline sql output truncated

Reply by damir.vadas_531

@Denis,

Here is mine picture once more.

Could you please tell me what is wrong here? What am I missing?

Brg

Damir

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.


#6

@Denis,

I have tested on latest beta as poster said. What is the problem here? Do not get it?


#7

@denis thanks

@damir sorry for the confusion. try F5


#8

O K i see now … script is really a bug (new one … in previousbeta version 12.5.0.31) I just can confirmed it was ok.

Now is not.

8(


#9

Looks like your running with F9. Run with F5 and you’ll see the problem. If you don’t, let me know.

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Monday, March 24, 2014 1:05 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] multiline sql output truncated

RE: multiline sql output truncated

Reply by damir.vadas_531

@Denis,

I have tested on latest beta as poster said. What is the problem here? Do not get it?

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.


#10

@laurentc.schneider,

Please look what you get when you press F5:

and now look at your initial post for which I said it is strange.

If you presented output window then still something is missing. In one word your initial post was really misleading and in certain way incorrect in description (output).

I have spent more time to describe what is not but you did what is the problem…

Brg

Damir


#11

Damir : No, it is not incorrect. Here my screenshot without your nice red squares


#12

OK. If this is from Toad, where did you get this line (please allow nice red parts to accent what seems to be not so visible to you):

SQL> select ‘1’|| chr(10) || ‘2’|| chr(10) || ‘3’ from dual


#13

never heard of SET ECHO ON?


#14

@laurentc,
This is not nice from you. What I’m trying to say is that you faulty described your case. I do not want to say F5 or F9 but we have additional commands in example.
I’m sorry to waste so much time to try to help you. But it was worth of one thing. Maybe you now know a little more more about placing all commands and appropriate result in problem description, what was AGAIN NOT THE CASE in your post.

Ok now we come to moment where your original post looks like:

SET ECHO ON
select ‘1’|| chr(10) || ‘2’|| chr(10) || ‘3’ from dual

Brg,
Damir