# Execute a stub written in plsql

**URL:** <https://www.ruby-forum.com/t/execute-a-stub-written-in-plsql/184201>\
**Category:** Ruby\
**Created:** [February 26, 2010, 5:04pm UTC](https://www.ruby-forum.com/t/execute-a-stub-written-in-plsql/184201 "2010-02-26T17:04:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![xboxer21](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/8baadc/32.png) [@xboxer21](https://www.ruby-forum.com/u/xboxer21)\
**Post date:** [February 26, 2010, 5:04pm UTC](https://www.ruby-forum.com/t/execute-a-stub-written-in-plsql/184201/1 "2010-02-26T17:04:31Z")

</div>

Hello All,  
how can I use ruby to execute a block of plsql code?  
The sql that I’m trying to execute is inside a .sql file  
here is what I’ve tried so far and it does not work.  
What is the right way to get this working so that I can capture the dbms  
output to a variable?

require “rubygems”  
require “ruby-plsql”

sql = s = IO.read(‘my\_sql\_stub.sql’)  
plsql.connection = OCI8.new(“user”,“pass”,“db”)  
plsql.execute(sql)

Thanks in advance for your help.