# Using rails with stored procedures **URL:** \ **Category:** Rails\ **Created:** [December 20, 2005, 12:18pm UTC](https://www.ruby-forum.com/t/using-rails-with-stored-procedures/50717 "2005-12-20T12:18:00Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Gioachino\_Bartolott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c77e96/32.png) [@Gioachino\_Bartolott](https://www.ruby-forum.com/u/Gioachino_Bartolott)\ **Post date:** [December 20, 2005, 12:18pm UTC](https://www.ruby-forum.com/t/using-rails-with-stored-procedures/50717/1 "2005-12-20T12:18:00Z")
Hi all! I am quite new to rails, and I would like to know if there is a tutorial, or if someone can tell me how to use rails with stored procedures and views. Any help would be appreciated. ## Thanks to all ---
**Author:** ![Gioachino\_Bartolott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c77e96/32.png) [@Gioachino\_Bartolott](https://www.ruby-forum.com/u/Gioachino_Bartolott)\ **Post date:** [December 20, 2005, 12:51pm UTC](https://www.ruby-forum.com/t/using-rails-with-stored-procedures/50717/2 "2005-12-20T12:51:06Z")
Gioachino Bartolotta wrote: > Hi all! > I am quite new to rails, and I would like to know if there is a > tutorial, or if someone can tell me how to use rails with stored > procedures and views. > Any help would be appreciated. Views you can use as an ActiveRecord model, save, create and update won’t work ofcourse, unless you setup your DB to support updatable views. I imagine you can run stores procedures with YourModel.connecion.select\_value(“SELECT myfunction()”) or something similar. Triggers will ofcourse work transparently through ActiveRecord, but be sure to reload the model after a save operation as the trigger may have caused the object to go “out of sync”, if you know what I mean. Jeroen ---
**Author:** ![Gioachino\_Bartolott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c77e96/32.png) [@Gioachino\_Bartolott](https://www.ruby-forum.com/u/Gioachino_Bartolott)\ **Post date:** [December 20, 2005, 8:44pm UTC](https://www.ruby-forum.com/t/using-rails-with-stored-procedures/50717/3 "2005-12-20T20:44:52Z")
Gioachino, Are you using Microsoft SQL Server? If so, I think you could run the following sql to return a recordset from a Stored Proc.: " EXEC yourStoredProcName @param=‘value’ " (However, I believe this will not return any OUTPUT parameters or Return Codes) ---
**Author:** ![Gioachino\_Bartolott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c77e96/32.png) [@Gioachino\_Bartolott](https://www.ruby-forum.com/u/Gioachino_Bartolott)\ **Post date:** [December 20, 2005, 9:51pm UTC](https://www.ruby-forum.com/t/using-rails-with-stored-procedures/50717/4 "2005-12-20T21:51:19Z")
Hi Ed! I am using PostgreSQL … I work only on \*nix like system Right noe I am trying to see how rails work with views … 😉 Thanks guys for your help … 2005/12/20, Ed C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > ## – Gioachino Bartolotta Mobile: 320 6059371 ICQ #: 9103167 MSN Messenger: removed\_email\_address@domain.invalid Yahoo & Skype: gioachino\_bartolotta ---
**Author:** ![Gioachino\_Bartolott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c77e96/32.png) [@Gioachino\_Bartolott](https://www.ruby-forum.com/u/Gioachino_Bartolott)\ **Post date:** [December 21, 2005, 12:22am UTC](https://www.ruby-forum.com/t/using-rails-with-stored-procedures/50717/5 "2005-12-21T00:22:21Z")
Stored Procedures is not the rails way… All features that make our database, [business] smart we hate… ---
**Author:** ![Gioachino\_Bartolott](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c77e96/32.png) [@Gioachino\_Bartolott](https://www.ruby-forum.com/u/Gioachino_Bartolott)\ **Post date:** [December 21, 2005, 3:42am UTC](https://www.ruby-forum.com/t/using-rails-with-stored-procedures/50717/6 "2005-12-21T03:42:45Z")
Leon L. wrote: > Stored Procedures is not the rails way… > > All features that make our database, [business] smart we hate… Agreed - even microsoft is heading that direction with LINQ. Stored procs are soooo 90’s …