APEX

Ok, so I found out that you can't use two Automated Row Fetch processes on one page so I decided to do it manually.

I wrote this On-load (Before / After Header) PL/SQL process to populate my form:

DECLARE
in_party_id NUMBER;

BEGIN
in_party_id := v('P4_PARTY_ID');

FOR rec IN (select PARTY_ID,
NAME,
START_DATE,
END_DATE
from PARTY
where PARTY_ID = in_party_id)
LOOP
:P4_PARTY_ID := rec.PARTY_ID;
:P4_NAME := rec.NAME;
:P4_START_DATE := rec.START_DATE;
:P4_END_DATE := rec.END_DATE;
END LOOP;
END;

Now the items :P4_PARTY_ID, P4_NAME.... etc are all set to:

'Always.....'
'Static Assignment....'

When I load the page with the passed in value the fields don't show any values but when i click 'Session' in the development toolbar the values show and change depending on the selected row from the report on the previous page.

So my pl/sql works but nothing shows, I've cleared the cache, logged in and out of the application, logged in and out of apex just to make sure nothing is cached to no avail.

I'm really at my wits end with such a simple procedure, any help would be much appreciated!

Cheers,

Rich.