Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

get rowid from the following select...

AtonMay 13 2011 — edited May 13 2011
Hi,

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!!!
This post has been answered by Solomon Yakobson on May 13 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2011
Added on May 13 2011
4 comments
484 views