get rowid from the following select...
AtonMay 13 2011 — edited May 13 2011Hi,
I have the following select statment:
SELECT *
FROM
TABLE( CAST(
T_DATE_CLIENT.getCLIENT(:p_date) AS OBJ_CLIENT))
Where T_DATE_CLIENT is a Package, :p_date a parameter and OBJ_CLIENT is an objet,
what i need is to appear the rowid column without adding it into the package or objet, i mean, something like this
SELECT A.*, A.rowid
FROM
TABLE( CAST(
T_DATE_CLIENT.getCLIENT(:p_date) AS OBJ_CLIENT)) A
but this doesn't work :(
if someone can help me it would be very appreciated.
Thx in advance!!!