How to use ROWID in Pro*C

From: Syed Azam <syed_azam_at_rsmi.com>
Date: 1997/03/22
Message-ID: <33345B1C.5C4A_at_rsmi.com>#1/1


I am trying to capture the rowid of a row in table that needs to be updated later. I have defined a VARCHAR variable to store the rowid. I am using the function rowidtochar to store the value of rowid.

Select rowidtochar(rowid) from table_a into :table_a_rowid;

However, when i try to update the column using this variable to identify the rowid, I do not find that row.

If there is better or correct approach in doing this please let me know.

Syed Azam Received on Sat Mar 22 1997 - 00:00:00 CET

Original text of this message