I am trying to insert data into a read only form using following sql query:
begin select s.ID, s.SPID, s.PHONE_NUMBER INTO :P9_ID,:P9_SPID,:P9_PHONE_NUMBER FROM TABLE1 s left outer join TABLE2 f on f.ID=s.ID where f.ID=:P9_TBL2_ID; end;
However I always get the error no data found when using the where clause, although the page element has an explicit value (here number 5).
When I change the where clause to
I get the right data inserted into the read only form.
Can you please help here?