From: Bharath Khambadkone on 26 Feb 2010 11:04
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?
sql = s = IO.read('my_sql_stub.sql')
plsql.connection = OCI8.new("user","pass","db")
Thanks in advance for your help.
Posted via http://www.ruby-forum.com/.