This discussion is archived
1 Reply Latest reply: Feb 9, 2013 12:11 PM by matthew_morris RSS

edit page fetching with rowid problem

850128 Newbie
Currently Being Moderated
Hi! I have an interactive report from a view and have a rowid column that is a link to a page to edit a table.

The rowid value in db is: ABH/WVAG1AAAAF9AAA

But the generated link is:

f?p=XXX:24:9420765805297::NO::P24_ROWID:ABH%26#x2F;WVAG1AAAAF7AAA

And when it loads the page it happens a no data found error (because the escaped characters)

What would be the solution for this problem?
  • 1. Re: edit page fetching with rowid problem
    matthew_morris Expert
    Currently Being Moderated
    Using ROWIDs as the primary keys for a table isn't really a good practice -- despite the fact that Oracle decided to include the capability in Apex. I will do it... on very rare occasions, when I have a tiny lookup table that really has no need of PKs. The best solution would be to switch to using a real primary key column for that table. That said, it may well not be a practical one for you.

    You might try placing a process in the Page rendering section that runs before the row fetch. Have it do something like:

    BEGIN
    :P24_ROWID := REPLACE(:P24_ROWID, '%26#x2F;', '/');
    END;

    Not something I've ever needed to attempt, so untested...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points