kubo / ruby-oci8

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

OCI8.__execute hangs using procedure when on sql dev works #162

Closed MarioRuiz closed 7 years ago

MarioRuiz commented 7 years ago

hangs on __execute method on cursor.rb `require 'oci8'

conn = OCI8.new('dddd','aaaaa','xxx.xxx.xxx.xxx')

sql="Declare x INTEGER; BEGIN MYPROC(pBeepid => x,pPrimaryBeepid => null, pZoomId => 'ZOOLAND',pPrimaryZoomId => 'ZOOLAND', pDoomName => 'SammE', pBlinkingTime => TO_DATE('2017-03-03','YYYY-MM-DD'), pDoomingTime => TO_DATE('2017-03-05','YYYY-MM-DD'), pCreated => CURRENT_TIMESTAMP, pDoomData => null); END;"

conn.exec(sql)`

is there any limitation on oci8? why is not throwing any error message?