From: Saurabh Narain <saurabhnarain@...>
Date: 2010-10-11T04:22:39+09:00
Subject: `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?
-- 
Posted via http://www.ruby-forum.com/.