# Errors not displaying in Toad for Oracle

**URL:** <https://forums.toadworld.com/t/errors-not-displaying-in-toad-for-oracle/32327>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 15, 2015, 12:20pm UTC](https://forums.toadworld.com/t/errors-not-displaying-in-toad-for-oracle/32327 "2015-01-15T12:20:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![larrickl](https://avatars.discourse-cdn.com/v4/letter/l/3ec8ea/32.png) [@larrickl](https://forums.toadworld.com/u/larrickl)\
**Post date:** [January 15, 2015, 12:20pm UTC](https://forums.toadworld.com/t/errors-not-displaying-in-toad-for-oracle/32327/1 "2015-01-15T12:20:54Z")

</div>

I originally used Toad for analysts (or Toad Data Point). When there is an error, it tells you the line and what the error is. In Toad for Oracle, often the error will just have the first line of the code and space 7 (after the word Select). This just tells me the error is in the select statement, but not where or what the error is. Is there a setting I should have checked which will give more information? Thank you in advance. – Lee

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [January 17, 2015, 1:10pm UTC](https://forums.toadworld.com/t/errors-not-displaying-in-toad-for-oracle/32327/2 "2015-01-17T13:10:21Z")

</div>

Hi,

I do not use Toad Data point....so have no idea what do you see.

And in Toad please please take a look what I have:

F9 (run as query):

![F9.png](https://global.discourse-cdn.com/quest/original/2X/1/1b408a86b95f738ced3ea1b922849341523f776c.png)

As you see error is correctly shown.

F5 (run as script):

 ![F5.png](https://global.discourse-cdn.com/quest/original/2X/6/63f2439607664e96ee9f8fd8b9bd1ca1d4efd388.png)

again error is correctly highlighted.

fI you can place pictures of the same SQL error in both programs it may be more understandable...to help you better.

Hope this helps ...

Cheers,

Damir

---

<div class="post-metadata">

**Author:** ![larrickl](https://avatars.discourse-cdn.com/v4/letter/l/3ec8ea/32.png) [@larrickl](https://forums.toadworld.com/u/larrickl)\
**Post date:** [January 20, 2015, 6:16am UTC](https://forums.toadworld.com/t/errors-not-displaying-in-toad-for-oracle/32327/3 "2015-01-20T06:16:53Z")

</div>

Thank you for the response Damir. When I get an error which doesn’t give me the line, I’ll post pictures from each application.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [January 20, 2015, 7:03am UTC](https://forums.toadworld.com/t/errors-not-displaying-in-toad-for-oracle/32327/4 "2015-01-20T07:03:07Z")

</div>

Please be aware that you should explain the way code is runned … i.e. like script or like query or like selected query etc …