# Saving data in 12.1.0.3 is a problem

**URL:** <https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882>\
**Category:** Toad for Oracle - Beta\
**Created:** [July 19, 2013, 6:57am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882 "2013-07-19T06:57:14Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\
**Post date:** [July 19, 2013, 6:57am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/1 "2013-07-19T06:57:14Z")

</div>

When I want to use to save the data grid in 12.1.0.3 I get the following error:

[Window Title]

Warning

[Main Instruction]

Toad Message

[Content]

The dataset does not contain data.

[OK]

This error goes away if you check the box with “Display all results in grid”.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 19, 2013, 7:09am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/2 "2013-07-19T07:09:45Z")

</div>

Are you saying that the database DOES contain data, or that you don’t want to see the message?

**From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]

**Sent:** Friday, July 19, 2013 8:58 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

**[ Saving data in 12.1.0.3 is a  
problem](http://gyk.r.mailjet.com/redirect/v53lt28wvcqd9hdcsg8hrv/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx)**

Thread created by wimdelange\_062

When I want to use to save the data grid in 12.1.0.3 I get the following error:

[Window Title]

Warning

[Main Instruction]

Toad Message

[Content]

The dataset does not contain data.

[OK]

This error goes away if you check the box with “Display all results in grid”.

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/7t8lhv2dzycsbflmj2jp7r/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/5dnktd5d5wd974csg5cr0w/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/n8z8tp5w7rlx9hwv9r746p/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?AbuseContentId=335cdd4c-99cf-4b13-91da-25dfff34b592&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/11b9e06e/48Y2f2.gif)

---

<div class="post-metadata">

**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\
**Post date:** [July 20, 2013, 12:49am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/3 "2013-07-20T00:49:48Z")

</div>

The result of the query contains data. But if the "display all results in grid" is off, Toad thinks there is no data to export. Which indicates two problems. 1) There is data, but it won't export. 2) And if there was no data, it should export and not give an error. The fact that a report is empty should not lead to an error. Maybe I'm interested in a field list with no records in the selected format.

But for starters, the fact that "Display results in grid" is off should not lead to the fact that Toad thinks there is no date, while clearly there is.

Groetjes,  
Wim

2013/7/19 John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)

> **[RE: Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/4k3rhf25sfxbvdpnl77h0y/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40060.aspx#40060)**

> Reply by John Dorlon  
> Are you saying that the database DOES contain data, or that you don’t want to see the message?

> 

> **From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]
> 
> **Sent:** Friday, July 19, 2013 8:58 AM
> 
> **To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)
> 
> **Subject:** [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

> **[ Saving data in 12.1.0.3 is a  
> problem](http://gyk.r.mailjet.com/redirect/rty3hntr3dwt9dvbn83j4q/gyk.r.mailjet.com/redirect/v53lt28wvcqd9hdcsg8hrv/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx)**

> Thread created by wimdelange\_062

> When I want to use to save the data grid in 12.1.0.3 I get the following error:

> 

> [Window Title]

> Warning

> 

> [Main Instruction]

> Toad Message

> 

> [Content]

> The dataset does not contain data.

> 

> [OK]

> 

> This error goes away if you check the box with "Display all results in grid".

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/3d9jt7446vph6ov531xg8j/gyk.r.mailjet.com/redirect/7t8lhv2dzycsbflmj2jp7r/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/895ktm6hw6fnos1nt94ngp/gyk.r.mailjet.com/redirect/5dnktd5d5wd974csg5cr0w/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/6l58h14lk8zmtgx50do6j8/gyk.r.mailjet.com/redirect/n8z8tp5w7rlx9hwv9r746p/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?AbuseContentId=335cdd4c-99cf-4b13-91da-25dfff34b592&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
> this post as spam/abuse.

> 

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/ynvkhb1n3v0gd81p76t59v/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.
> 
> Or [Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/5387tnjccnf5sty3v3z05q/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/f7rctzgs54zxjyvw7dvzom/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40060.aspx?AbuseContentId=49e886af-c4e1-4edc-9447-b6faedbef389&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

>

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [July 20, 2013, 5:04am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/4 "2013-07-20T05:04:48Z")

</div>

PLUS – one should always set  
“display all results in grid” to off for efficiency/performance reasons. So if this is not working, then it’s a best practice that doesn’t work  
L

Bert

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 22, 2013, 9:29am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/5 "2013-07-22T09:29:58Z")

</div>

Hi Wim,

I think this is what happened:

1. 

You had the “threaded queries” option enabled, which runs DML and selects in the editor in their own session.

1. 

You had some freshly inserted, but not committed rows in your dataset

1. 

When you exported with ‘display all results in grid’ unchecked, Toad executed a separate (nonthreaded, not in the same session as the editor) query  
to pull data….but since it was uncommitted, well, you know the rest…

I should be able to make it use the same session as the threaded query. For now, do a commit first and it should work.

-John

**From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]

**Sent:** Saturday, July 20, 2013 2:50 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** Re: [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

**[ Re: Saving data in  
12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/5zmytyyvxj70xcy35g47nj/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40075.aspx#40075)**

Reply by wimdelange\_062

The result of the query contains data. But if the “display all results in grid” is off, Toad thinks there is no data to export. Which indicates two problems. 1) There is data,  
but it won’t export. 2) And if there was no data, it should export and not give an error. The fact that a report is empty should not lead to an error. Maybe I’m interested in a field list with no records in the selected format.

But for starters, the fact that “Display results in grid” is off should not lead to the fact that Toad thinks there is no date, while clearly there is.

Groetjes,

Wim

2013/7/19 John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)

**[ RE:  
Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/0vq9tvp79kc4n1lbjpgjdz/gyk.r.mailjet.com/redirect/4k3rhf25sfxbvdpnl77h0y/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40060.aspx#40060)**

Reply by John Dorlon

Are you saying that the database DOES contain data, or that you don’t want to see the message?

**From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]

**Sent:** Friday, July 19, 2013 8:58 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

**[ Saving  
data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/nq1ntrmw2sky2hgcxs35cv/gyk.r.mailjet.com/redirect/rty3hntr3dwt9dvbn83j4q/gyk.r.mailjet.com/redirect/v53lt28wvcqd9hdcsg8hrv/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx)**

Thread created by wimdelange\_062

When I want to use to save the data grid in 12.1.0.3 I get the following error:

[Window Title]

Warning

[Main Instruction]

Toad Message

[Content]

The dataset does not contain data.

[OK]

This error goes away if you check the box with “Display all results in grid”.

To reply, please reply-all to this email.

[ Stop  
receiving emails](http://gyk.r.mailjet.com/redirect/3wqpt4s80xgmpmlndgx08s/gyk.r.mailjet.com/redirect/3d9jt7446vph6ov531xg8j/gyk.r.mailjet.com/redirect/7t8lhv2dzycsbflmj2jp7r/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/wwfwhkzgsh0trw9ww8xv4l/gyk.r.mailjet.com/redirect/895ktm6hw6fnos1nt94ngp/gyk.r.mailjet.com/redirect/5dnktd5d5wd974csg5cr0w/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/dq6ntxq6ockltf62gyx4zg/gyk.r.mailjet.com/redirect/6l58h14lk8zmtgx50do6j8/gyk.r.mailjet.com/redirect/n8z8tp5w7rlx9hwv9r746p/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?AbuseContentId=335cdd4c-99cf-4b13-91da-25dfff34b592&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/6p0mt2xzznh4h1db1ph3z1/gyk.r.mailjet.com/redirect/ynvkhb1n3v0gd81p76t59v/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false)  
on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/z1t1tlzbztj5v61cn9og4p/gyk.r.mailjet.com/redirect/5387tnjccnf5sty3v3z05q/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/3005t3rk1v8n7jv9vm5f8z/gyk.r.mailjet.com/redirect/f7rctzgs54zxjyvw7dvzom/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40060.aspx?AbuseContentId=49e886af-c4e1-4edc-9447-b6faedbef389&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/qfvphyxcx7pzbxf9knlzcc/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/9osjt1mjql22z44cqdd4fv/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/d6gftpr64v7d20l5cb17sq/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40075.aspx?AbuseContentId=99a91cf8-8c99-4a00-8e08-c4ae045c0c6c&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/ee3f4a1e/49sM4V.gif)

---

<div class="post-metadata">

**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\
**Post date:** [July 23, 2013, 1:05am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/6 "2013-07-23T01:05:01Z")

</div>

Sorry, but that is not a correct description of the situation.  
I have the "threaded queries" option enabled (who hasn't :-)?).

But I don't have freshly inserted rows.

I start Toad, run the query that get me the totals of the general ledger of the previous month, I see some date on the screen (Row 1 of 500 fetched so far (more rows exists)) and then do the save to Excel (xlsx) with the 'Display all results in grid" off, giving the following result:

[Window Title]

Warning

[Main Instruction]

Toad Message

[Content]

The dataset does not contain data.

[OK]

Let me know if you want more information (Toad settings, Oracle versions, etc).

Did some further testing. I cannot produce this error in another Oracle database? So there is a dependency somewhere.

What fails is Oracle 10, but Oracle 9 is OK. I don't have a clue what the difference is between the users I use to access the database in both systems. What type of information can you use?

Groetjes,  
Wim

2013/7/22 John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)

> **[RE: Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/9jcfty34d1g4cwwz3608x4/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40091.aspx#40091)**

> Reply by John Dorlon  
> Hi Wim,

> 

> I think this is what happened:

> 

> 1. 
> 
> You had the “threaded queries” option enabled, which runs DML and selects in the editor in their own session.

> 1. 
> 
> You had some freshly inserted, but not committed rows in your dataset

> 1. 
> 
> When you exported with ‘display all results in grid’ unchecked, Toad executed a separate (nonthreaded, not in the same session as the editor) query  
> to pull data….but since it was uncommitted, well, you know the rest…

> 

> I should be able to make it use the same session as the threaded query. For now, do a commit first and it should work.

> 

> -John

> 

> 

> **From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]
> 
> **Sent:** Saturday, July 20, 2013 2:50 AM
> 
> **To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)
> 
> **Subject:** Re: [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

> **[ Re: Saving data in  
> 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/wby9t8dbt1dvxbvv012198/gyk.r.mailjet.com/redirect/5zmytyyvxj70xcy35g47nj/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40075.aspx#40075)**

> Reply by wimdelange\_062

> The result of the query contains data. But if the "display all results in grid" is off, Toad thinks there is no data to export. Which indicates two problems. 1) There is data,  
> but it won't export. 2) And if there was no data, it should export and not give an error. The fact that a report is empty should not lead to an error. Maybe I'm interested in a field list with no records in the selected format.

> 

> But for starters, the fact that "Display results in grid" is off should not lead to the fact that Toad thinks there is no date, while clearly there is.

> 

> Groetjes,
> 
> Wim

> 

> 2013/7/19 John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)

> **[ RE:  
> Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/b6hphqkbownqjm6n77jf3k/gyk.r.mailjet.com/redirect/0vq9tvp79kc4n1lbjpgjdz/gyk.r.mailjet.com/redirect/4k3rhf25sfxbvdpnl77h0y/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40060.aspx#40060)**

> Reply by John Dorlon

> Are you saying that the database DOES contain data, or that you don’t want to see the message?

> 

> **From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]
> 
> **Sent:** Friday, July 19, 2013 8:58 AM
> 
> **To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

> **Subject:** [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

> 

> **[ Saving  
> data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/vmv6t5qqkt97wkkgb4jdj4/gyk.r.mailjet.com/redirect/nq1ntrmw2sky2hgcxs35cv/gyk.r.mailjet.com/redirect/rty3hntr3dwt9dvbn83j4q/gyk.r.mailjet.com/redirect/v53lt28wvcqd9hdcsg8hrv/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx)**

> Thread created by wimdelange\_062

> When I want to use to save the data grid in 12.1.0.3 I get the following error:

> 

> [Window Title]

> Warning

> 

> [Main Instruction]

> Toad Message

> 

> [Content]

> The dataset does not contain data.

> 

> [OK]

> 

> This error goes away if you check the box with "Display all results in grid".

> To reply, please reply-all to this email.
> 
> [ Stop  
> receiving emails](http://gyk.r.mailjet.com/redirect/hongh38p9g4plh0382sy0x/gyk.r.mailjet.com/redirect/3wqpt4s80xgmpmlndgx08s/gyk.r.mailjet.com/redirect/3d9jt7446vph6ov531xg8j/gyk.r.mailjet.com/redirect/7t8lhv2dzycsbflmj2jp7r/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/lm7gt3cvbblnry1mvlkrw4/gyk.r.mailjet.com/redirect/wwfwhkzgsh0trw9ww8xv4l/gyk.r.mailjet.com/redirect/895ktm6hw6fnos1nt94ngp/gyk.r.mailjet.com/redirect/5dnktd5d5wd974csg5cr0w/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/z7tjt586w9oh7dg7m21v8n/gyk.r.mailjet.com/redirect/dq6ntxq6ockltf62gyx4zg/gyk.r.mailjet.com/redirect/6l58h14lk8zmtgx50do6j8/gyk.r.mailjet.com/redirect/n8z8tp5w7rlx9hwv9r746p/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?AbuseContentId=335cdd4c-99cf-4b13-91da-25dfff34b592&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
> this post as spam/abuse.

> 

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/4257h6jzm7yf477rf81b6q/gyk.r.mailjet.com/redirect/6p0mt2xzznh4h1db1ph3z1/gyk.r.mailjet.com/redirect/ynvkhb1n3v0gd81p76t59v/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false)  
> on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/ypv8tx6k50s1yddq1r45m1/gyk.r.mailjet.com/redirect/z1t1tlzbztj5v61cn9og4p/gyk.r.mailjet.com/redirect/5387tnjccnf5sty3v3z05q/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/fdzyt2j76ftwyx7s2tmd7g/gyk.r.mailjet.com/redirect/3005t3rk1v8n7jv9vm5f8z/gyk.r.mailjet.com/redirect/f7rctzgs54zxjyvw7dvzom/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40060.aspx?AbuseContentId=49e886af-c4e1-4edc-9447-b6faedbef389&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

> 

> 

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/gvjwhm5gyt5sx65w2od197/gyk.r.mailjet.com/redirect/qfvphyxcx7pzbxf9knlzcc/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/qsfmhvd8l745sx81cxlqnl/gyk.r.mailjet.com/redirect/9osjt1mjql22z44cqdd4fv/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/vq6zhlggg8c41tgsg5kqqh/gyk.r.mailjet.com/redirect/d6gftpr64v7d20l5cb17sq/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40075.aspx?AbuseContentId=99a91cf8-8c99-4a00-8e08-c4ae045c0c6c&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

> 

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/1fwotbn39dl4q5xfsc2glp/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.
> 
> Or [Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/z7lltxgpyhc4nwh4tzjopy/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/s579h2yc8oy7pdzg2mpzw7/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40091.aspx?AbuseContentId=ac7a6d51-3b44-487e-9a35-03a633309246&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

>

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [July 23, 2013, 5:05am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/7 "2013-07-23T05:05:02Z")

</div>

I tried to reproduce this on 10.2.0.5 and cannot get your issue. So it has to be some obscure setting I’m guessing. So imagine John will want your toad.ini  
at a min – maybe even a zipped copy of your user files directory ……

**From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]

**Sent:** Tuesday, July 23, 2013 3:06 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** Re: [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

**[ Re: Saving data in  
12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/ksvtt1f3p1c3jc5x6hkp2k/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40101.aspx#40101)**

Reply by wimdelange\_062

Sorry, but that is not a correct description of the situation.

I have the “threaded queries” option enabled (who hasn’t :-)?).

But I don’t have freshly inserted rows.

I start Toad, run the query that get me the totals of the general ledger of the previous month, I see some date on the screen (Row 1 of 500 fetched so far (more rows exists))  
and then do the save to Excel (xlsx) with the 'Display all results in grid" off, giving the following result:

[Window Title]

Warning

[Main Instruction]

Toad Message

[Content]

The dataset does not contain data.

[OK]

Let me know if you want more information (Toad settings, Oracle versions, etc).

Did some further testing. I cannot produce this error in another Oracle database? So there is a dependency somewhere.

What fails is Oracle 10, but Oracle 9 is OK. I don’t have a clue what the difference is between the users I use to access the database in both systems. What type of information  
can you use?

Groetjes,

Wim

2013/7/22 John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)

**[ RE:  
Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/4thtt9vmmn6w77l128vc7y/gyk.r.mailjet.com/redirect/9jcfty34d1g4cwwz3608x4/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40091.aspx#40091)**

Reply by John Dorlon

Hi Wim,

I think this is what happened:

1. 

You had the “threaded queries” option enabled, which runs DML and selects in the editor in their own session.

1. 

You had some freshly inserted, but not committed rows in your dataset

1. 

When you exported with ‘display all results in grid’ unchecked, Toad executed a separate (nonthreaded, not in the same session as the editor) query to pull data….but since  
it was uncommitted, well, you know the rest…

I should be able to make it use the same session as the threaded query. For now, do a commit first and it should work.

-John

**From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]

**Sent:** Saturday, July 20, 2013 2:50 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** Re: [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

**[ Re:  
Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/dccbh0s1ccfrvol33qn9dd/gyk.r.mailjet.com/redirect/wby9t8dbt1dvxbvv012198/gyk.r.mailjet.com/redirect/5zmytyyvxj70xcy35g47nj/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40075.aspx#40075)**

Reply by wimdelange\_062

The result of the query contains data. But if the “display all results in grid” is off, Toad thinks there is no data to export. Which indicates two problems. 1) There is data,  
but it won’t export. 2) And if there was no data, it should export and not give an error. The fact that a report is empty should not lead to an error. Maybe I’m interested in a field list with no records in the selected format.

But for starters, the fact that “Display results in grid” is off should not lead to the fact that Toad thinks there is no date, while clearly there is.

Groetjes,

Wim

2013/7/19 John Dorlon [bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)

**[ RE:  
Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/bwhqhc48mp09hm1qb99y1n/gyk.r.mailjet.com/redirect/b6hphqkbownqjm6n77jf3k/gyk.r.mailjet.com/redirect/0vq9tvp79kc4n1lbjpgjdz/gyk.r.mailjet.com/redirect/4k3rhf25sfxbvdpnl77h0y/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40060.aspx#40060)**

Reply by John Dorlon

Are you saying that the database DOES contain data, or that you don’t want to see the message?

**From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]

**Sent:** Friday, July 19, 2013 8:58 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

**[ Saving  
data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/3h1bt6ds1ccnzqxoxq27c9/gyk.r.mailjet.com/redirect/vmv6t5qqkt97wkkgb4jdj4/gyk.r.mailjet.com/redirect/nq1ntrmw2sky2hgcxs35cv/gyk.r.mailjet.com/redirect/rty3hntr3dwt9dvbn83j4q/gyk.r.mailjet.com/redirect/v53lt28wvcqd9hdcsg8hrv/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx)**

Thread created by wimdelange\_062

When I want to use to save the data grid in 12.1.0.3 I get the following error:

[Window Title]

Warning

[Main Instruction]

Toad Message

[Content]

The dataset does not contain data.

[OK]

This error goes away if you check the box with “Display all results in grid”.

To reply, please reply-all to this email.

[ Stop  
receiving emails](http://gyk.r.mailjet.com/redirect/wxtnt0kd82qglqh0x7nd88/gyk.r.mailjet.com/redirect/hongh38p9g4plh0382sy0x/gyk.r.mailjet.com/redirect/3wqpt4s80xgmpmlndgx08s/gyk.r.mailjet.com/redirect/3d9jt7446vph6ov531xg8j/gyk.r.mailjet.com/redirect/7t8lhv2dzycsbflmj2jp7r/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/12bhhch7nm6l586vq9zfy4/gyk.r.mailjet.com/redirect/lm7gt3cvbblnry1mvlkrw4/gyk.r.mailjet.com/redirect/wwfwhkzgsh0trw9ww8xv4l/gyk.r.mailjet.com/redirect/895ktm6hw6fnos1nt94ngp/gyk.r.mailjet.com/redirect/5dnktd5d5wd974csg5cr0w/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/o8r7hodxz3l67zshj4f5wb/gyk.r.mailjet.com/redirect/z7tjt586w9oh7dg7m21v8n/gyk.r.mailjet.com/redirect/dq6ntxq6ockltf62gyx4zg/gyk.r.mailjet.com/redirect/6l58h14lk8zmtgx50do6j8/gyk.r.mailjet.com/redirect/n8z8tp5w7rlx9hwv9r746p/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?AbuseContentId=335cdd4c-99cf-4b13-91da-25dfff34b592&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

To reply, please reply-all to this email.

[ Stop  
receiving emails](http://gyk.r.mailjet.com/redirect/h77qhjslqll46jmfovfbhb/gyk.r.mailjet.com/redirect/4257h6jzm7yf477rf81b6q/gyk.r.mailjet.com/redirect/6p0mt2xzznh4h1db1ph3z1/gyk.r.mailjet.com/redirect/ynvkhb1n3v0gd81p76t59v/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/grq5h3q8z9jlq20mn5vvcy/gyk.r.mailjet.com/redirect/ypv8tx6k50s1yddq1r45m1/gyk.r.mailjet.com/redirect/z1t1tlzbztj5v61cn9og4p/gyk.r.mailjet.com/redirect/5387tnjccnf5sty3v3z05q/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/4gzwt1fx1s9kblbqy6qkoy/gyk.r.mailjet.com/redirect/fdzyt2j76ftwyx7s2tmd7g/gyk.r.mailjet.com/redirect/3005t3rk1v8n7jv9vm5f8z/gyk.r.mailjet.com/redirect/f7rctzgs54zxjyvw7dvzom/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40060.aspx?AbuseContentId=49e886af-c4e1-4edc-9447-b6faedbef389&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

To reply, please reply-all to this email.

[ Stop  
receiving emails](http://gyk.r.mailjet.com/redirect/qvx8hnl5r3pr42fpzo6l7h/gyk.r.mailjet.com/redirect/gvjwhm5gyt5sx65w2od197/gyk.r.mailjet.com/redirect/qfvphyxcx7pzbxf9knlzcc/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/lhywtr8fro4x3gl5pqsbn4/gyk.r.mailjet.com/redirect/qsfmhvd8l745sx81cxlqnl/gyk.r.mailjet.com/redirect/9osjt1mjql22z44cqdd4fv/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/jp14tg900flfxmtm0rvtbf/gyk.r.mailjet.com/redirect/vq6zhlggg8c41tgsg5kqqh/gyk.r.mailjet.com/redirect/d6gftpr64v7d20l5cb17sq/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40075.aspx?AbuseContentId=99a91cf8-8c99-4a00-8e08-c4ae045c0c6c&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/t6qotqzmd9dwxbr56oxopg/gyk.r.mailjet.com/redirect/1fwotbn39dl4q5xfsc2glp/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false)  
on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/0nyot5155qo43kfzpj8l86/gyk.r.mailjet.com/redirect/z7lltxgpyhc4nwh4tzjopy/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/158zhh0chy1h80rlrq228t/gyk.r.mailjet.com/redirect/s579h2yc8oy7pdzg2mpzw7/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40091.aspx?AbuseContentId=ac7a6d51-3b44-487e-9a35-03a633309246&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/4wfmtttcrns0y46qwpl5oy/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/mojkhl37x7td6zhoocv1xf/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/05x0hdmqx5fp2qnj8mlxq7/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40101.aspx?AbuseContentId=bbdcae33-4f15-489e-bcb5-8d405fc537f8&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/b6d709b5/4biuTC.gif)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 23, 2013, 6:15am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/8 "2013-07-23T06:15:02Z")

</div>

Could there be some other reason why a different session wouldn’t see the rows? It IS a different session when threaded queries is enabled. I have fixed  
that for next beta…which should be today. Please try it again when that becomes available.

It’s interesting to hear that it only happens on your 10g database. I don’t think your user files folder will reveal anything to me.

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [July 23, 2013, 7:30am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/9 "2013-07-23T07:30:02Z")

</div>

Afternoon all,  
On 23/07/13 14:15, John Dorlon wrote:

> \*RE: Saving data in 12.1.0.3 is a problem  
> \*
> 
> Reply by John Dorlon  
> Could there be some other reason why a different session wouldn’t see  
> the rows? It IS a different session when threaded queries is  
> enabled.  
> There is a possibility that the Editor session - filling the grid with data to be saved - might not be able to see [some] data if that missing data was:

- Added or changed by other session(s) and committed; AND
- Added or changed after the start of the transaction for the statement filling the grid; AND
- The grid session executed a "set transaction read only;" statement; AND
- The grid session is not SYS.  
(Phew!)  
That doesn't mean that there cannot be inserts or updates etc, merely that the grid session will not see any newly committed data after the execution of the above "set transaction"command. It has also to be the very first statement in the transaction, so something like the following in the grid session:  
connect norman/secret  
...  
commit;  
set transaction read only;  
select stuff for grid;  
...  
commit;  
So, the first commit ends the transaction and begins a new one. The SET TRANSACTION makes this transaction unable to see new data added by other sessions after the start of this transaction, even if the data are committed. The final commit ends the read only (a bad name if ever there was one!) transaction.  
Example:  
Session 1: select \* from norm;  
a

* * *

## 616 Session 1: set transaction read only; Transaction set. Session 1: select \* from norm; a

## 616 Session 2: insert into norm values (666); Session 2: commit; Session 2: select \* from norm; a

## 616 666 Session 1: select \* from norm; a

## 616 So, session 1 still cannot see any new data, inserted or updated, and committed, since the start of it's current transaction. If we continue in session 1: Session 1: commit; Commit complete. Session 1: select \* from norm; a

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [July 23, 2013, 7:40am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/10 "2013-07-23T07:40:03Z")

</div>

## On 23/07/13 15:30, Norm [TeamT] wrote: A seemingly truncated email! It was fine when it left me, honest! The bits missing are as follows: If we continue in session 1: Session 1: commit; Commit complete. Session 1: select \* from norm; a

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [July 23, 2013, 7:45am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/11 "2013-07-23T07:45:02Z")

</div>

# Well now, something odd is happening! I’ll try again! If we continue in session 1: Session 1: commit; Commit complete. Session 1: select \* from norm; a

616  
666  
The above is the only way that I can think of to prevent one session from seeing data that were changed or added, and committed, by another session.  
The big problem with the above is, this isn’t happening in the “other” session that is fetching the data to write out to the disc file, Excel or whatever! But is is a way in which one transaction can be prevented from seeing committed data.  
Other than this, and the obvious reasons given by Bert, I can’t think of any reason why the background session in Toad, wanting to export the data, is not able to see the committed data visible to the editor session that filled the grid.  
– Cheers,  
Norm. [TeamT]  
– Cheers,  
Norm. [TeamT]

---

<div class="post-metadata">

**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\
**Post date:** [July 30, 2013, 4:45am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/12 "2013-07-30T04:45:36Z")

</div>

Problem is still there in 12.1.0.5. The following query on a table (not a view) generates 1083 records (year - 2013, period - 2)

SELECT company

,accounting\_year

,accounting\_period

,account

,SUM(amount\_balance) total\_amount

FROM accounting\_balance\_tab

WHERE accounting\_year = :year

AND accounting\_period = :period

GROUP BY company

,accounting\_year

,accounting\_period

,account

This creates a spreadsheet with the records

But if Display all results in grid is checked off, the following happens, even when I don't redo the query. So there is data. And there are no ongoing transactions.

And as stated before, this happens for this user and this database. I cannot reproduce this in another environment.

Groetjes,  
Wim

2013/7/23 Norm [TeamT] [bounce-NormTeamT@toadworld.com](mailto:bounce-NormTeamT@toadworld.com)

> **[Re: Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/97ybh0qsqghoj3l6y5zctc/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40108.aspx#40108)**

> Reply by Norm [TeamT]

> Well now, something odd is happening! I'll try again!
> 
> If we continue in session 1:
> 
> Session 1: commit;
> 
> Commit complete.
> 
> Session 1: select \* from norm;
> 
> a

> =====
> 
> 616
> 
> 666
> 
> The above is the only way that I can think of to prevent one session
> 
> from seeing data that were changed or added, and committed, by another
> 
> session.
> 
> The big problem with the above is, this isn't happening in the "other"
> 
> session that is fetching the data to write out to the disc file, Excel
> 
> or whatever! But is is a way in which one transaction can be prevented
> 
> from seeing committed data.
> 
> Other than this, and the obvious reasons given by Bert, I can't think of
> 
> any reason why the background session in Toad, wanting to export the
> 
> data, is not able to see the committed data visible to the editor
> 
> session that filled the grid.
> 
> --
> 
> Cheers,
> 
> Norm. [TeamT]
> 
> --
> 
> Cheers,
> 
> Norm. [TeamT]

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/8mthtkjpr3qyw4k08hqjw6/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.
> 
> Or [Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/qd80tody62915dnm366kz1/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/fr03tp9sgbyj2wh838n8h0/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40108.aspx?AbuseContentId=985850b2-8a18-40c4-b980-9edf36724258&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

>

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [July 30, 2013, 4:50am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/13 "2013-07-30T04:50:38Z")

</div>

John is on vacation – and he normally handles these issues. So you may need to wait a week or two for him to get back and caught up ….

**From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]

**Sent:** Tuesday, July 30, 2013 6:46 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** Re: [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

**[ Re: Saving data in  
12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/7w85td0sjjz4vytwyyb7d1/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40263.aspx#40263)**

Reply by wimdelange\_062

Problem is still there in 12.1.0.5. The following query on a table (not a view) generates 1083 records (year - 2013, period - 2)

SELECT company

```
    ,accounting_year

    ,accounting_period

    ,account

    ,SUM(amount_balance) total_amount

```

FROM accounting\_balance\_tab

WHERE accounting\_year = :year

```
     AND accounting_period = :period

```

GROUP BY company

```
    ,accounting_year

    ,accounting_period

    ,account

```

This creates a spreadsheet with the records

![Inline afbeelding 1](http://www.toadworld.com/cfs-filesystemfile.ashx/__key/communityserver-mailgateway-mailroom-forumshandler/464c677f4ef244dab65d9b3594d8df8d/image.png)

But if Display all results in grid is checked off, the following happens, even when I don't redo the query. So there is data. And there are no ongoing transactions.

![Inline afbeelding 2](http://www.toadworld.com/cfs-filesystemfile.ashx/__key/communityserver-mailgateway-mailroom-forumshandler/37894b5ca6b14caea87362ad7215c6c3/image.png)

And as stated before, this happens for this user and this database. I cannot reproduce this in another environment.

Groetjes,

Wim

2013/7/23 Norm [TeamT] [bounce-NormTeamT@toadworld.com](mailto:bounce-NormTeamT@toadworld.com)

**[ Re:  
Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/f2gyhxf716yvtgwfl9tr51/gyk.r.mailjet.com/redirect/97ybh0qsqghoj3l6y5zctc/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40108.aspx#40108)**

Reply by Norm [TeamT]

Well now, something odd is happening! I'll try again!

If we continue in session 1:

Session 1: commit;

Commit complete.

Session 1: select \* from norm;

a

=====

616

666

The above is the only way that I can think of to prevent one session

from seeing data that were changed or added, and committed, by another

session.

The big problem with the above is, this isn't happening in the "other"

session that is fetching the data to write out to the disc file, Excel

or whatever! But is is a way in which one transaction can be prevented

from seeing committed data.

Other than this, and the obvious reasons given by Bert, I can't think of

any reason why the background session in Toad, wanting to export the

data, is not able to see the committed data visible to the editor

session that filled the grid.

--

Cheers,

Norm. [TeamT]

--

Cheers,

Norm. [TeamT]

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/y24hhfgof5xvkh2khv98lb/gyk.r.mailjet.com/redirect/8mthtkjpr3qyw4k08hqjw6/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false)  
on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/ntlltyhqwq5k5gdy4z1rlg/gyk.r.mailjet.com/redirect/qd80tody62915dnm366kz1/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/x916t5b3vrl8wykthrol28/gyk.r.mailjet.com/redirect/fr03tp9sgbyj2wh838n8h0/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40108.aspx?AbuseContentId=985850b2-8a18-40c4-b980-9edf36724258&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/9kdjhhr2x9npc85qt784v1/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/l1xvhqlzvpzo99o4ccwb7k/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/osdyh4vvsnzfzcw9hy6top/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40263.aspx?AbuseContentId=5f915c8b-dc6c-44c1-9d5d-06350c2ba01e&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/a86736c5/4halRl.gif)

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [July 30, 2013, 5:10am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/14 "2013-07-30T05:10:36Z")

</div>

Afternoon Wim,  
On 30/07/13 12:51, Bert Scalzo wrote:

> Reply by Bert Scalzo  
> John is on vacation – and he normally handles these issues. So you may  
> need to wait a week or two for him to get back and caught up ….  
> Do me a favour please. Can you turn SQL Spooling on from the point where you are just about to execute your own query to populate the grid in Toad, then run it as normal and as you described, to create an Excel spreadsheet.  
> Use all the options that you mentioned that prevent you getting data into Excel please.  
> That way, we might be able to see something that is amiss in the spooled output. Assuming that it's a database problem of course!  
> Just trying to think of something that might help. If Toad's own spooling doesn't help, I'm going to suggest going down the road of a 10046 level 12 trace aka DBMS\_SUPPORT.START\_TRACE\_IN\_SESSION aka DBMS\_MONITOR.SESSION\_TRACE\_ENABLE.  
> Using Toad's own spooling will maybe show what's going on/wrong.  
> Cheers,  
> Norm.  
> -- Cheers,  
> Norm. [TeamT]

---

<div class="post-metadata">

**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\
**Post date:** [July 30, 2013, 5:20am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/15 "2013-07-30T05:20:36Z")

</div>

To be clear, this has nothing to do with multiple session or threading. The data in period 2013-02 is not changing (period 2013-02 is closed in the ledger). I've switched off the threaded execution in Toad and still the problem is there. It is only the check box together with something in this user that Toad decides not to write the information.

Did some more testing. If I use another table and use rownum to limit the number of records (499, 600, 1083), there is never a problem.

But if the query is run against another table and the result should contain the same data (accounting information against general ledger and result is the same) it generates the error. So there is something really strange going on.

The structure of the query plays a role? But how?

Groetjes,  
Wim

2013/7/23 Norm [TeamT] [bounce-NormTeamT@toadworld.com](mailto:bounce-NormTeamT@toadworld.com)

> **[Re: Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/97ybh0qsqghoj3l6y5zctc/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40108.aspx#40108)**

> Reply by Norm [TeamT]

> Well now, something odd is happening! I'll try again!
> 
> If we continue in session 1:
> 
> Session 1: commit;
> 
> Commit complete.
> 
> Session 1: select \* from norm;
> 
> a

> =====
> 
> 616
> 
> 666
> 
> The above is the only way that I can think of to prevent one session
> 
> from seeing data that were changed or added, and committed, by another
> 
> session.
> 
> The big problem with the above is, this isn't happening in the "other"
> 
> session that is fetching the data to write out to the disc file, Excel
> 
> or whatever! But is is a way in which one transaction can be prevented
> 
> from seeing committed data.
> 
> Other than this, and the obvious reasons given by Bert, I can't think of
> 
> any reason why the background session in Toad, wanting to export the
> 
> data, is not able to see the committed data visible to the editor
> 
> session that filled the grid.
> 
> --
> 
> Cheers,
> 
> Norm. [TeamT]
> 
> --
> 
> Cheers,
> 
> Norm. [TeamT]

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/8mthtkjpr3qyw4k08hqjw6/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.
> 
> Or [Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/qd80tody62915dnm366kz1/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Beta Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/fr03tp9sgbyj2wh838n8h0/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40108.aspx?AbuseContentId=985850b2-8a18-40c4-b980-9edf36724258&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

>

---

<div class="post-metadata">

**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\
**Post date:** [July 30, 2013, 5:25am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/16 "2013-07-30T05:25:36Z")

</div>

Did some extra testing.  
The problem is not there in toad 11.6.043 but it is also existing in Toad 12.0.0.61. All 64 bits. Same query, same export.

Groetjes,  
Wim

2013/7/30 Wim de Lange [wimdelange@gmail.com](mailto:wimdelange@gmail.com)

> To be clear, this has nothing to do with multiple session or threading. The data in period 2013-02 is not changing (period 2013-02 is closed in the ledger). I've switched off the threaded execution in Toad and still the problem is there. It is only the check box together with something in this user that Toad decides not to write the information.

> Did some more testing. If I use another table and use rownum to limit the number of records (499, 600, 1083), there is never a problem.

> 

> But if the query is run against another table and the result should contain the same data (accounting information against general ledger and result is the same) it generates the error. So there is something really strange going on.

> 

> The structure of the query plays a role? But how?

> 

> Groetjes,  
> Wim

> 2013/7/23 Norm [TeamT] [bounce-NormTeamT@toadworld.com](mailto:bounce-NormTeamT@toadworld.com)
> 
> > **[Re: Saving data in 12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/97ybh0qsqghoj3l6y5zctc/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40108.aspx#40108)**

> > Reply by Norm [TeamT]

> > Well now, something odd is happening! I'll try again!
> > 
> > If we continue in session 1:
> > 
> > Session 1: commit;
> > 
> > Commit complete.
> > 
> > Session 1: select \* from norm;
> > 
> > a

> > =====
> > 
> > 616
> > 
> > 666
> > 
> > The above is the only way that I can think of to prevent one session
> > 
> > from seeing data that were changed or added, and committed, by another
> > 
> > session.
> > 
> > The big problem with the above is, this isn't happening in the "other"
> > 
> > session that is fetching the data to write out to the disc file, Excel
> > 
> > or whatever! But is is a way in which one transaction can be prevented
> > 
> > from seeing committed data.
> > 
> > Other than this, and the obvious reasons given by Bert, I can't think of
> > 
> > any reason why the background session in Toad, wanting to export the
> > 
> > data, is not able to see the committed data visible to the editor
> > 
> > session that filled the grid.
> > 
> > --
> > 
> > Cheers,
> > 
> > Norm. [TeamT]
> > 
> > --
> > 
> > Cheers,
> > 
> > Norm. [TeamT]

> > To reply, please reply-all to this email.
> > 
> > [Stop receiving emails](http://gyk.r.mailjet.com/redirect/8mthtkjpr3qyw4k08hqjw6/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/19897.aspx?subscribe=false) on this subject.
> > 
> > Or [Unsubscribe from Toad for Oracle - Beta](http://gyk.r.mailjet.com/redirect/qd80tody62915dnm366kz1/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.
> > 
> > Toad for Oracle - Beta Discussion Forum

> > [Flag](http://gyk.r.mailjet.com/redirect/fr03tp9sgbyj2wh838n8h0/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40108.aspx?AbuseContentId=985850b2-8a18-40c4-b980-9edf36724258&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

> >

>

---

<div class="post-metadata">

**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\
**Post date:** [July 30, 2013, 5:40am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/17 "2013-07-30T05:40:37Z")

</div>

The Toad spool file.

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:58.490

BEGIN DBMS\_OUTPUT.ENABLE(buffer\_size =\> NULL); END;

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:58.533

BEGIN DBMS\_OUTPUT.ENABLE(buffer\_size =\> NULL); END;

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:58.620

SELECT company

,accounting\_year

,accounting\_period

,account

,SUM(amount\_balance) total\_amount

FROM accounting\_balance\_tab

WHERE accounting\_year = :year

AND accounting\_period = :period

GROUP BY company

,accounting\_year

,accounting\_period

,account

:year(VARCHAR[4],IN)=‘2013’

:period(VARCHAR[2],IN)=‘02’

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:59.185

begin dbms\_output.get\_line(line =\> :line, status =\> :status); end;

:line(LONG,OUT)=

:status(INTEGER,OUT)=

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:59.188

BEGIN DBMS\_OUTPUT.DISABLE; END;

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:59.218

BEGIN DBMS\_OUTPUT.DISABLE; END;

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [July 30, 2013, 5:55am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/18 "2013-07-30T05:55:37Z")

</div>

Dumb question – all those dbms\_output calls make me ask – are you using execute (f9) or execute as script (f5) ???

There is a major difference that might explain why you’re having issues ……

**From:** wimdelange\_062 [[mailto:bounce-wimdelange\_062@toadworld.com](mailto:bounce-wimdelange_062@toadworld.com)]

**Sent:** Tuesday, July 30, 2013 7:41 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** Re: [Toad for Oracle - Beta Discussion Forum] Saving data in 12.1.0.3 is a problem

**[ Re: Saving data in  
12.1.0.3 is a problem](http://gyk.r.mailjet.com/redirect/943ptohn35zy6f0pm7ovo7/www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/19897/40272.aspx#40272)**

Reply by wimdelange\_062

The Toad spool file.

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:58.490

BEGIN DBMS\_OUTPUT.ENABLE(buffer\_size =\> NULL); END;

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:58.533

BEGIN DBMS\_OUTPUT.ENABLE(buffer\_size =\> NULL); END;

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:58.620

SELECT company

```
    ,accounting_year

    ,accounting_period

    ,account

    ,SUM(amount_balance) total_amount

```

FROM accounting\_balance\_tab

WHERE accounting\_year = :year

```
     AND accounting_period = :period

```

GROUP BY company

```
    ,accounting_year

    ,accounting_period

    ,account

```

:year(VARCHAR[4],IN)=‘2013’

:period(VARCHAR[2],IN)=‘02’

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:59.185

begin dbms\_output.get\_line(line =\> :line, status =\> :status); end;

:line(LONG,OUT)=

:status(INTEGER,OUT)=

* * *

Session: IFSAPP@IFS\_PROD

Timestamp: 14:30:59.188

BEGIN DBMS\_OUTPUT.DISABLE; END;

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [July 30, 2013, 6:20am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/19 "2013-07-30T06:20:38Z")

</div>

Hi Wim,  
thanks for that.  
On 30/07/13 13:40, wimdelange\_062 wrote:

> The Toad spool file.
> 
> * * *
> 
> ## Session: IFSAPP@IFS\_PROD Timestamp: 14:30:58.490 BEGIN DBMS\_OUTPUT.ENABLE(buffer\_size =\> NULL); END; DBMS\_OUTPUT? I'm confused! Is this part of your SQL that is giving problems or has it appeared from toad itself? Never miknd, I've raun a test on Toad 12 myself, it appears that Toad is adding this, even when I execute an SQL with F9 and not with F5. I wonder if this is the cause of the problem? I have tried this on a Toad 11 system, connecting to the same test database as I used for Toad 12, and when I run that SQL, I only see the SQL statement, there are no DBMS\_OUTPUT statements.
> 
> Session: IFSAPP@IFS\_PROD  
> Timestamp: 14:30:58.620  
> SELECT company  
> ,accounting\_year  
> ,accounting\_period  
> ,account  
> ,SUM(amount\_balance) total\_amount  
> FROM accounting\_balance\_tab  
> WHERE accounting\_year = :year  
> AND accounting\_period = :period  
> GROUP BY company  
> ,accounting\_year  
> ,accounting\_period  
> ,account  
> :year(VARCHAR[4],IN)='2013'  
> :period(VARCHAR[2],IN)='02'
> 
> * * *

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [July 30, 2013, 6:30am UTC](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882/20 "2013-07-30T06:30:36Z")

</div>

On 30/07/13 14:21, Norm [TeamT] wrote:  
The following was sent with my last post to this problem/thread, but was missing when the email arrived back here:  
BEGIN:  
At least we can see that your values are being used.

> More DBMS\_OUTPUT stuff removed...  
> I am now wondering if the DBMS\_OUTPUT that appears to be running in the background is responsible for your problem? However, I'm unable to get it to fail to create an "export" of the grid - but as my test rig doesn't have Excel installed, I used CSV to Clipboard instead. Not sure if that affects things or not.  
> Still, we found a difference!  
> END.  
> I think, it's all those hyphens on the output. or some reason - possibly because two together at the start of a line - indicate end of text/start of sig.  
> Might be a Thunderbird thing, might be the web converting replies to whatever it sends out. I don;t know, but it's not the first time this has happened with one of my replies. ☹  
> -- Cheers,  
> Norm. [TeamT]

[Next page](https://forums.toadworld.com/t/saving-data-in-12-1-0-3-is-a-problem/25882.md?page=2)
