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
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