search

kubo / ruby-oci8

Ruby-oci8 - Oracle interface for ruby
Other
169 stars 75 forks source link

oci.exec has some problem #63

Closed a9cQ0Q closed 9 years ago

a9cQ0Q commented 9 years ago

Hello everyone

     I got the some problem,There's my tables:

PROGRAM_NAME VARCHAR WORK_FLAG VARCHAR START_DATE VARCHAR

When i use object.exec('SELECT * FROM table WHERE PROGRAM_NAME="SomeIn"') I got the error blow, but when i change to (WHERE START_DATE=20141120) there was be ok..

stmt.c:230:in oci8lib_210.bundle: ORA-00911: invalid character (OCIError)
    from /Users/xxx/.rvm/gems/ruby-2.1.5/gems/ruby-oci8-2.1.7/lib/oci8/cursor.rb:126:in `exec'
    from /Users/xxx/.rvm/gems/ruby-2.1.5/gems/ruby-oci8-2.1.7/lib/oci8/oci8.rb:278:in `exec_internal'
    from /Users/xxx/.rvm/gems/ruby-2.1.5/gems/ruby-oci8-2.1.7/lib/oci8/oci8.rb:269:in `exec'
    from SomeIn.rb:7:in `<main>'

It;s a problem or ? And those SQL statement it ok on the TOAD.