Use of bind variables using OCI8

ruby-talk
1

Hey Guys,

I am having some issues with the use of bind variables...

When I use...

···

------------
connFC = OCI8.new(<mydb>)

connFC.exec("SELECT * from emp where id = #{id}") { |row|
}
------------

it works perfectly fine...but when I modify to use bind variables for
Number type...

-------------
connFC = OCI8.new(<mydb>)

cursorFC = connFC.parse("SELECT * from emp where id = :1")
cursorFC.bind_param(1, id)

cursorFC.exec("SELECT * from emp where id = #{id}") { |row|
}
-------------

I get no resultset...can you please tell me, what I might be missing?
Do, I need to instantiate cursorFC to OCI8::Cursor or anything else,
which I might be missing? Thanks for your help.

---Harnish
--
Posted via http://www.ruby-forum.com/.

2

Thanks guys...

My issue got resolved..

I was missing the fetch method...

···

-------------------------------
connFC = OCI8.new(<mydb>)

cursorFC = connFC.parse("SELECT * from emp where id = :1")
cursorFC.bind_param(1, id)

cursorFC.exec()

cursorFC.fetch() { |row|
}
-------------------------------

works like a charm! Thanks...

---Harnish

Harnish Botadra wrote:

Hey Guys,

I am having some issues with the use of bind variables...

When I use...

------------
connFC = OCI8.new(<mydb>)

connFC.exec("SELECT * from emp where id = #{id}") { |row|
}
------------

it works perfectly fine...but when I modify to use bind variables for
Number type...

-------------
connFC = OCI8.new(<mydb>)

cursorFC = connFC.parse("SELECT * from emp where id = :1")
cursorFC.bind_param(1, id)

cursorFC.exec("SELECT * from emp where id = #{id}") { |row|
}
-------------

I get no resultset...can you please tell me, what I might be missing?
Do, I need to instantiate cursorFC to OCI8::Cursor or anything else,
which I might be missing? Thanks for your help.

---Harnish

--
Posted via http://www.ruby-forum.com/\.