# TOAD Script Error

**URL:** <https://forums.toadworld.com/t/toad-script-error/9489>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 11, 2010, 7:23am UTC](https://forums.toadworld.com/t/toad-script-error/9489 "2010-05-11T07:23:49Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 11, 2010, 7:23am UTC](https://forums.toadworld.com/t/toad-script-error/9489/1 "2010-05-11T07:23:49Z")

</div>

Good Morning All,  
I am running a script that builds a series of dynamic sql statements (like select count(\*),‘FARACHG’ from FIMSMGR.FARACHG;) against a set of oracle tables. I spool these statements in the first step and then run the spooled op in the second.

I started running into this message --\> “Maximum grid count exceeded. Grids will no longer be created” at about release 9.? a while back. Despite my best efforts, I can’t seem to locate a setting to increase this parameter(?). It appears to be set at 100 at the moment.

Anyone have any ideas what I’m running into and how to -fix- it?

TIA,

Tim

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [May 11, 2010, 7:55am UTC](https://forums.toadworld.com/t/toad-script-error/9489/2 "2010-05-11T07:55:14Z")

</div>

Tim,  
We fixed the max grids at 100 due to memory considerations and some limitations in the controls we’re using.

Greg

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 11, 2010, 8:37am UTC](https://forums.toadworld.com/t/toad-script-error/9489/3 "2010-05-11T08:37:37Z")

</div>

Thanks Greg, I’ll adjust accordingly…  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/278be512a68050c664416c8c1dd90a338bc191af.jpeg)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 11, 2010, 8:37am UTC](https://forums.toadworld.com/t/toad-script-error/9489/4 "2010-05-11T08:37:37Z")

</div>

Thanks Greg, I’ll adjust accordingly…  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg)

---

<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:** [May 11, 2010, 8:41am UTC](https://forums.toadworld.com/t/toad-script-error/9489/5 "2010-05-11T08:41:47Z")

</div>

Tim,

> > ... Despite my best efforts, I can't seem to  
> > locate a setting to increase this parameter(?). It appears  
> > to be set at 100 at the moment.
> > 
> > Anyone have any ideas what I'm running into and how to -fix- it?

Does it help if you go to view-\>Toad Options-\>Execute/compile and  
uncheck the option to "show script grids"?

I usually have this unchecked so I only get the results for the whole  
script in one script output tab. I don't get the individual output  
grids.

Cheers,  
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk)

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.  
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk)

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [May 11, 2010, 8:47am UTC](https://forums.toadworld.com/t/toad-script-error/9489/6 "2010-05-11T08:47:33Z")

</div>

Think about using EXECUTE immediate. We used to have 2 step jobs also. One to spool and then the second to execute what was spooled. It was simpler to control to turn them all into EXECUTE immediate. I also created a procedure that would take a variable and do one of three things:

1. just dbms\_output the info
2. execute and dbms\_output
3. execute only

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [May 11, 2010, 8:48am UTC](https://forums.toadworld.com/t/toad-script-error/9489/7 "2010-05-11T08:48:23Z")

</div>

The script should keep executing but just won’t make any more than 100 grids. Of course it’ll be faster if you turn the grids off like Norm does.

Greg [TeamCaffeine]
