`exec': wrong number of arguments (0 for 1) (ArgumentError)

Ruby
1

Hi All,

I’m new to ruby and I’m facing one issue when connecting to Oracle 11g
database from a ruby program…

conn = OCI8.new(‘user’, ‘passwd’, ‘db’)
cursor = conn.parse(“SELECT SUB_ID FROM LOOKUPS WHERE TYPE LIKE
‘CHANNEL_TYPE’ and LOWER(TRIM(name)) = :channelType”)
cursor.bind_param(’:channelType’, channelType.downcase)
cursor = conn.exec()

I’m getting `exec’: wrong number of arguments (0 for 1) (ArgumentError)
on the last line. My ruby version is 1.8.7 and OS is Ubuntu 10.04.

Can someone pls help me?

2

My bad it should have been
cursor.exec() and not conn.exec()