# \[TDP 3.6\] Oracle Stored Procedures - Create, Alter but Cannot Execute...

**URL:** <https://forums.toadworld.com/t/tdp-3-6-oracle-stored-procedures-create-alter-but-cannot-execute/33155>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 21, 2015, 6:23am UTC](https://forums.toadworld.com/t/tdp-3-6-oracle-stored-procedures-create-alter-but-cannot-execute/33155 "2015-04-21T06:23:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![N.B](https://avatars.discourse-cdn.com/v4/letter/n/bc8723/32.png) [@N.B](https://forums.toadworld.com/u/N.B)\
**Post date:** [April 21, 2015, 6:23am UTC](https://forums.toadworld.com/t/tdp-3-6-oracle-stored-procedures-create-alter-but-cannot-execute/33155/1 "2015-04-21T06:23:34Z")

</div>

I’ve always thought it was odd with TDA/TDP that you could Create and Alter Oracle Stored Procedures, but you can’t execute them - at least not from the Editor or from an Automation ‘Execute Script’ activity.

Why is that?

Example:

Running the exact same command in Toad for Oracle, SQL\*Plus, Benthic’s Golden, etc. all work fine - but not TDP.

---

<div class="post-metadata">

**Author:** ![GregDavis11009](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gregdavis11009/32/122_2.png) [@GregDavis11009](https://forums.toadworld.com/u/GregDavis11009)\
**Post date:** [April 21, 2015, 7:47am UTC](https://forums.toadworld.com/t/tdp-3-6-oracle-stored-procedures-create-alter-but-cannot-execute/33155/2 "2015-04-21T07:47:20Z")

</div>

Is your connection the same in both Toad for Oracle and TDP?

---

<div class="post-metadata">

**Author:** ![N.B](https://avatars.discourse-cdn.com/v4/letter/n/bc8723/32.png) [@N.B](https://forums.toadworld.com/u/N.B)\
**Post date:** [April 21, 2015, 8:25am UTC](https://forums.toadworld.com/t/tdp-3-6-oracle-stored-procedures-create-alter-but-cannot-execute/33155/3 "2015-04-21T08:25:44Z")

</div>

Yes; in fact Toad for Oracle was installed after TDP, and imported TDP’s connection for this particular database.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [April 23, 2015, 2:02pm UTC](https://forums.toadworld.com/t/tdp-3-6-oracle-stored-procedures-create-alter-but-cannot-execute/33155/4 "2015-04-23T14:02:50Z")

</div>

I can execute proc in block in the editor. This works fine. We just don’t support any SQL\*Plus commands and perhaps that is what you are using.

BEGIN

:P\_ORDER\_ID := 1234;

:P\_DISCOUNT := 10;

QUEST\_DEV.BILL\_ORDER ( :P\_ORDER\_ID, :P\_DISCOUNT );

END;

---

<div class="post-metadata">

**Author:** ![N.B](https://avatars.discourse-cdn.com/v4/letter/n/bc8723/32.png) [@N.B](https://forums.toadworld.com/u/N.B)\
**Post date:** [April 27, 2015, 1:02pm UTC](https://forums.toadworld.com/t/tdp-3-6-oracle-stored-procedures-create-alter-but-cannot-execute/33155/5 "2015-04-27T13:02:48Z")

</div>

Hi Debbie,

That was the issue. EXEC/EXECUTE in SQL\*Plus is short hand for ‘BEGIN END;’ - I’m just so used to all my tools using that syntax it didn’t occur to me that TDP might not support it.
