Skip to Main Content
Forums

APEX

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!

APEX 4.0.2. using ROWID in INTERACTIVE REPORT

roman1982Jun 30 2011 — edited Jul 7 2011
Hello *,

I have a problem using the rowid with interactive reports.

I have a table with IDs without any primary keys, constraints etc.

The only ID I want to change is the ID that characterizes a row.

Instead of using a new column 'ID' I thought I'd be better using the rowid.

So I created a new item P41152_ROWID in which the interactive report loads via 'Link Column' the value #ROWID#.

Works pretty well but on the next page the SQL Procedure

update TABLE set ID_ART = :P41154_ID_ART where ROWID = :P41154_ROWID;

excepts with an "invalid rowid" error.

Even

update TABLE set ID_ART = :P41154_ID_ART where ROWID = CHARTOROWID(:P41154_ROWID);

does not work.

Is there any hint? :-(

Edited by: roman on 30.06.2011 03:30
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2011
Added on Jun 30 2011
#apex, #apex-discussions, #oracle, #pl-sql, #query, #report
9 comments
3,092 views