# Oci8 oracle rowid

**URL:** <https://www.ruby-forum.com/t/oci8-oracle-rowid/115370>\
**Category:** Ruby\
**Created:** [September 24, 2007, 3:38pm UTC](https://www.ruby-forum.com/t/oci8-oracle-rowid/115370 "2007-09-24T15:38:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpaxton](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/8c91f0/32.png) [@mpaxton](https://www.ruby-forum.com/u/mpaxton)\
**Post date:** [September 24, 2007, 3:38pm UTC](https://www.ruby-forum.com/t/oci8-oracle-rowid/115370/1 "2007-09-24T15:38:36Z")

</div>

Whenever I try to read a rowid from an Oracle table, I get:

TypeError: not valid handle type Class

The OCI documentation says rowid is supported, and that the  
documentation on it is yet to be written. Anyone know how to read it?

---

<div class="post-metadata">

**Author:** ![mpaxton](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/8c91f0/32.png) [@mpaxton](https://www.ruby-forum.com/u/mpaxton)\
**Post date:** [September 24, 2007, 3:48pm UTC](https://www.ruby-forum.com/t/oci8-oracle-rowid/115370/2 "2007-09-24T15:48:45Z")

</div>

Odd, I can do something like:

c.execute(“select \* from dual where rowid = ‘AAAAECAABAAAAgiAAA’”)

but not:  
r=c.exec(‘select rowid from dual’)

Mark P. wrote:

> Whenever I try to read a rowid from an Oracle table, I get:
> 
> TypeError: not valid handle type Class
> 
> The OCI documentation says rowid is supported, and that the  
> documentation on it is yet to be written. Anyone know how to read it?