Hello Sir,
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
where f.ID=5;
I get the right data inserted into the read only form.
Can you please help here?
Vinish Kapoor
If you are using a DA to execute the above query, then you must add P9_TBL2_ID in the items to submit field.