help on ora_getColumnName needed

[watermark]

I am unable to retrieve rowid in this statement 'Select RowId, table_name.* from table_name".

ora_getcolumn reports "found invalid type (11)" when it tries to access the rowid.

I am using php4.2.2.

Appreciate your help.😕

[tsinka]

The rowid is of type ROWID. The PHP functions can't handle this row type. But you can do something like:

SELECT ROWIDTOCHAR(ROWID) AS rid, table_name.* FROM table_name

Thomas

[watermark]

It works! Thank you tsinka!