# Toad datapoint-DBMS Output

**URL:** <https://forums.toadworld.com/t/toad-datapoint-dbms-output/29302>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [March 13, 2014, 12:28pm UTC](https://forums.toadworld.com/t/toad-datapoint-dbms-output/29302 "2014-03-13T12:28:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![stl14](https://avatars.discourse-cdn.com/v4/letter/s/ed8c4c/32.png) [@stl14](https://forums.toadworld.com/u/stl14)\
**Post date:** [March 13, 2014, 12:28pm UTC](https://forums.toadworld.com/t/toad-datapoint-dbms-output/29302/1 "2014-03-13T12:28:48Z")

</div>

Hi,

At present I am using Toad Data Point in Oracle and using PL/SQL.

I have the following question and if possible please clarify me:

I have written a PL/SQL query in Oracle and using Toad Data Point. The query ran successfully but the report displays in the messages section of Results.

I stuck at this point and not able to create a Excel or Toad report as the next step. I think, I can do it if the query report displays in the datasets section.Is there anyway, I can do it in Messages section. I don’t know whether there is an option exists in Toad data point. Otherwise, is there any possible ways I can get the output file.

Thanks,

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [March 14, 2014, 1:37pm UTC](https://forums.toadworld.com/t/toad-datapoint-dbms-output/29302/2 "2014-03-14T13:37:10Z")

</div>

Hi,

I am sorry but I don’t know a way to redirect DBMS Output into a grid.

I’d suggest inserting the report into a temporary table and selecting from the table. In this case you can export the data into Excel or Toad report.

Or you can write directly into a file using UTL\_FILE instead of DBMS\_Output and after that export the file into Excel.

Regards

Aleksey
