Sha256: 023ecaaa79139b8b8828563c61c1088e60676ca2d48877fadf84060eb20c7ecc
Contents?: true
Size: 655 Bytes
Versions: 66
Compression:
Stored size: 655 Bytes
Contents
require 'oci8'
require File.dirname(__FILE__) + '/config'
class TestRowid < Minitest::Test
def setup
@conn = get_oci8_connection
end
def test_rowid
drop_table('test_table')
sql = <<-EOS
CREATE TABLE test_table (N NUMBER(38))
EOS
@conn.exec(sql)
cursor = @conn.parse("INSERT INTO test_table values(1)");
cursor.exec
rid1 = cursor.rowid
assert_instance_of(String, rid1)
cursor.close
rid2 = nil
@conn.exec('select rowid from test_table where rowid = :1', rid1) do |row|
rid2 = row[0]
end
assert_equal(rid2, rid1)
drop_table('test_table')
end
def teardown
@conn.logoff
end
end
Version data entries
66 entries across 66 versions & 1 rubygems