# It is possible to run Oracle packages from Toad Data Point 3.2?

**URL:** <https://forums.toadworld.com/t/it-is-possible-to-run-oracle-packages-from-toad-data-point-3-2/7594>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 17, 2013, 6:35pm UTC](https://forums.toadworld.com/t/it-is-possible-to-run-oracle-packages-from-toad-data-point-3-2/7594 "2013-02-17T18:35:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![leigh.sullivan2013](https://avatars.discourse-cdn.com/v4/letter/l/4da419/32.png) [@leigh.sullivan2013](https://forums.toadworld.com/u/leigh.sullivan2013)\
**Post date:** [February 17, 2013, 6:35pm UTC](https://forums.toadworld.com/t/it-is-possible-to-run-oracle-packages-from-toad-data-point-3-2/7594/1 "2013-02-17T18:35:42Z")

</div>

Hi,

It is possible to run Oracle packages from Toad Data Point 3.2?

Kind regards,

Leigh

---

<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:** [February 19, 2013, 12:15pm UTC](https://forums.toadworld.com/t/it-is-possible-to-run-oracle-packages-from-toad-data-point-3-2/7594/2 "2013-02-19T12:15:09Z")

</div>

What do you mean by “run Oracle packages”?  
The package navigation in Object Explorer (you can see the navigation on the left side of the Script tab of a package) has disable Execute right menu button action.  
And you cannot execute a package procedure/function from here.  
But you always can execute a procedure/function from the SQL editor using anonymous block.  
Also you can execute a function using the following template where it executes GET\_DDL from Dbms\_Metadata package to get DDL for the table ADDRESS  
SELECT DBMS\_METADATA.GET\_DDL(‘TABLE’, ‘ADDRESS’) FROM dual

Could you please clarify your question?

---

<div class="post-metadata">

**Author:** ![leigh.royus2013](https://avatars.discourse-cdn.com/v4/letter/l/a88e4f/32.png) [@leigh.royus2013](https://forums.toadworld.com/u/leigh.royus2013)\
**Post date:** [February 19, 2013, 7:06pm UTC](https://forums.toadworld.com/t/it-is-possible-to-run-oracle-packages-from-toad-data-point-3-2/7594/3 "2013-02-19T19:06:06Z")

</div>

Hi Aleksey,

It is the same “Leigh Roy” - my work was blocking emails from this site so I have created a new account with a different email.

Thanks for your reply, I think you have answered my question. I will just need to experiment a little.

Basically I have been given privileges with my work database user account to compile/execute procedures/packages using PL/SQL. We were told that ‘Toad (Data Point)’ would not be able to accommodate this and so ‘SQL developer’ was installed. However, I like using ‘Toad’ so am basically exploring what is possible in terms of using PL/SQL with ‘Toad’.

As for your text -

“Also you can execute a function using the following template where it executes GET\_DDL from Dbms\_Metadata package to get DDL for the table ADDRESS SELECT DBMS\_METADATA.GET\_DDL(‘TABLE’, ‘ADDRESS’) FROM dual”

do you know of any links to full examples on the net?

Kind regards,

Leigh

---

<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:** [February 20, 2013, 12:54pm UTC](https://forums.toadworld.com/t/it-is-possible-to-run-oracle-packages-from-toad-data-point-3-2/7594/4 "2013-02-20T12:54:25Z")

</div>

Hi Leigh

I am glad that you like TDP.  
You can look an example at [http://www.techonthenet.com/oracle/questions/exec\_function.php](http://www.techonthenet.com/oracle/questions/exec_function.php)

Aleksey