# CLR type Stored Procedures, didn't show in Transaction Group

**URL:** <https://forum.inductiveautomation.com/t/clr-type-stored-procedures-didnt-show-in-transaction-group/3646>\
**Category:** Ignition\
**Created:** [November 23, 2011, 2:02am UTC](https://forum.inductiveautomation.com/t/clr-type-stored-procedures-didnt-show-in-transaction-group/3646 "2011-11-23T02:02:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [November 23, 2011, 2:02am UTC](https://forum.inductiveautomation.com/t/clr-type-stored-procedures-didnt-show-in-transaction-group/3646/1 "2011-11-23T02:02:49Z")

</div>

Had this earlier today, Running 7.2.9 Ignition on a 32bit Win2003 machine.

Database connection was to a MSSQL 2005 database.

Trying to use a CLR type Stored Procedure, wouldn’t show up as an option in the Transaction Group(stored procedure type) dropdown.  
All the other Stored Procedures the acct had access too would show up.

Ideas?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [November 23, 2011, 6:22am UTC](https://forum.inductiveautomation.com/t/clr-type-stored-procedures-didnt-show-in-transaction-group/3646/2 "2011-11-23T06:22:33Z")

</div>

Even though it does’t show up, have you tried typing it in manually and testing it out?

---

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [November 23, 2011, 6:37pm UTC](https://forum.inductiveautomation.com/t/clr-type-stored-procedures-didnt-show-in-transaction-group/3646/3 "2011-11-23T18:37:50Z")

</div>

yeah, We got an error regarding not finding the variable types.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [November 29, 2011, 10:59pm UTC](https://forum.inductiveautomation.com/t/clr-type-stored-procedures-didnt-show-in-transaction-group/3646/4 "2011-11-29T22:59:10Z")

</div>

I’m not sure what the solution to this is. At some point, all data types have to get mapped to JDBC types, and I’m not sure how that would happen here. Is it possible to create a wrapper procedure that uses simple types and then calls the more advanced procedure?

Regards,

---

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [November 30, 2011, 1:09am UTC](https://forum.inductiveautomation.com/t/clr-type-stored-procedures-didnt-show-in-transaction-group/3646/5 "2011-11-30T01:09:54Z")

</div>

We did that yeah.

Still, would be nice for native support of the CLR type. 😃