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?
Discy Latest Questions
Hello Sir, to retrieve the status of a form from the logged in user, I did the following: - created application item 'STATE_OF_FORM'. - created application process to set the value into the application item this takes the status from a table and should set it in the application_item. Unfortunately it doesn't work as hoped, I think the error is in the syntax: --this is the code to set stored table status into the status application item declare v_state varchar2(50); begin select fp.STATE into v_state FROM PROCESSSTEPS_FORM fp left outer join USERS u on fp.UUID=u.UUID where u.username=:APP_USER; Apex_Util.Set_Session_State('STATE_OF_FORM', v_state); --exception handling needed otherwise the error 'ORA-01403: no data found' will exception be raised when no_data_found then NULL; end; What do I do wrong?