How do I include an oracle rowid in a Crystal report?

[heatherh]

All Oracle tables include a a system generated numbercolumn called rowid which provides a unique identifier for a record in a table. Can I include this column in a Crystal report as it does not appear on the list of database columns.

 

[kenhamady]

Someone else may have run into this, but if it doesn't appear in the list, I can't see any way to make it usable. Probably means that it isn't stored as a true column in the table. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Guest_imported]

There is a function in Oracle that will allow you to call the row-id. However this must be done thru a PL/SQL store procedure. Thus it would have to be process on the server side and then it could be available on the application side (Crystal). Could you please provide more details why you are trying to access the row-id? I hope this helps!

Keith Boyer-CDSE
Enterprise Reporting Practice Manager
888.394.1664

 

[darwin101]

SELECT ROWID, SYSDATE FROM DUAL

ROWID SYSDATE
AAAADDAABAAAAHSAAA 05-JUN-2001