# How to remove some errors message?

**URL:** <https://forums.toadworld.com/t/how-to-remove-some-errors-message/55462>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 16, 2022, 8:38am UTC](https://forums.toadworld.com/t/how-to-remove-some-errors-message/55462 "2022-06-16T08:38:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![informatik](https://avatars.discourse-cdn.com/v4/letter/i/da6949/32.png) [@informatik](https://forums.toadworld.com/u/informatik)\
**Post date:** [June 16, 2022, 8:38am UTC](https://forums.toadworld.com/t/how-to-remove-some-errors-message/55462/1 "2022-06-16T08:38:04Z")

</div>

I've a pipeplined function.

I write

`select * from pipelined_function`

this works but toad show me this message.

> found '(' expected external.

Therefore I write `select * from table(pipelined_function)` although that is not necessary.

That's another problem, but I can't use the autocompletion if write a function after from (without or with table).

I've exactly the same problems with a polymorphic table function. But the error is still printed, even if I add the table keyword

Are theses error messages justified?  
If not,is there a way to remove these error messages?

---

<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:** [June 16, 2022, 8:12pm UTC](https://forums.toadworld.com/t/how-to-remove-some-errors-message/55462/2 "2022-06-16T20:12:16Z")

</div>

Is that an ORA- error or a Toad formatter/parser error? Seems like the formatter would just think that's a table, so I am curious where the error comes from. Can you give a screenshot?

Also, can you give a small example for the polymorphic table function case?

Thanks

---

<div class="post-metadata">

**Author:** ![informatik](https://avatars.discourse-cdn.com/v4/letter/i/da6949/32.png) [@informatik](https://forums.toadworld.com/u/informatik)\
**Post date:** [June 17, 2022, 5:15am UTC](https://forums.toadworld.com/t/how-to-remove-some-errors-message/55462/3 "2022-06-17T05:15:14Z")

</div>

This is a Toad formatter/parser error.

 ![image](https://global.discourse-cdn.com/quest/original/2X/5/59eac320d4be4ec84658ae1fcbe09e8c5c29f25b.png)

NB: you must test with the user name, if you want to see the error

---

<div class="post-metadata">

**Author:** ![informatik](https://avatars.discourse-cdn.com/v4/letter/i/da6949/32.png) [@informatik](https://forums.toadworld.com/u/informatik)\
**Post date:** [June 17, 2022, 5:23am UTC](https://forums.toadworld.com/t/how-to-remove-some-errors-message/55462/4 "2022-06-17T05:23:38Z")

</div>

with a ptf:

 ![image](https://global.discourse-cdn.com/quest/original/2X/c/c0fd9c387ef64dfb55e0b6e1476dbadd8d9966e3.jpeg)

As you can see, it works but there is a parsor/formater error (with or without the keyword table)

---

<div class="post-metadata">

**Author:** ![informatik](https://avatars.discourse-cdn.com/v4/letter/i/da6949/32.png) [@informatik](https://forums.toadworld.com/u/informatik)\
**Post date:** [June 17, 2022, 5:31am UTC](https://forums.toadworld.com/t/how-to-remove-some-errors-message/55462/5 "2022-06-17T05:31:17Z")

</div>

NB: for a ptf too you must write the user so that the problem occurs.

In EVERY mentioned cases there is no autocompletion after the keyword from .

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [June 17, 2022, 6:03am UTC](https://forums.toadworld.com/t/how-to-remove-some-errors-message/55462/6 "2022-06-17T06:03:50Z")

</div>

Parser error. It's simply a SELECT from a qualified name with **two** dots which is not supported.

`SELECT col FROM a.b.c;`

Vielen Dank für den Hinweis. Will be fixed asap.  
Andre