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

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?

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs