# Calling a Oracle procedure inside ROR

**URL:** <https://www.ruby-forum.com/t/calling-a-oracle-procedure-inside-ror/177519>\
**Category:** Rails\
**Created:** [October 19, 2009, 5:33pm UTC](https://www.ruby-forum.com/t/calling-a-oracle-procedure-inside-ror/177519 "2009-10-19T17:33:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rafaelrosafu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/59ef9b/32.png) [@rafaelrosafu](https://www.ruby-forum.com/u/rafaelrosafu)\
**Post date:** [October 19, 2009, 5:33pm UTC](https://www.ruby-forum.com/t/calling-a-oracle-procedure-inside-ror/177519/1 "2009-10-19T17:33:40Z")

</div>

Hi all,auppose I have the following procedure:  
CREATE OR REPLACE Procedure Calc\_All\_Diarias(Pviagem In Number,  
Pcompl In Varchar2)  
I´m trying to call it this way:  
x = ActiveRecord::Base.connection.execute( “exec calc\_all\_diarias  
(5107,0);”)

If I put the statement directly into the PL/SQL Developer it runs just  
fine,but in ROR I´m receiving a "Invalid SQL Statement"error.What am I  
doing wrong?

Thanks,  
Rafael R.

---

<div class="post-metadata">

**Author:** ![rafaelrosafu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/59ef9b/32.png) [@rafaelrosafu](https://www.ruby-forum.com/u/rafaelrosafu)\
**Post date:** [October 19, 2009, 6:25pm UTC](https://www.ruby-forum.com/t/calling-a-oracle-procedure-inside-ror/177519/2 "2009-10-19T18:25:39Z")

</div>

anyone??