Hi All,
Good Day,
We are having problme with (V('APP_SESSION')) in existing application. The scenerio is as follows the data in tempoary tables are not getting deleted properly,
- When multiple browser was opened at a time and trying to fill the form.
- When trying to connect they desktop or laptop through "VPN" the forms gets some times freeze and we are assuming data is gets reatined in tempoary tables.
-When trying to fill form due to network connectivity problme data may retain in tempoary tables.
-APart from these we are not able to understand why the from gets freeze, as we had mention in point#2, not sure what could be exact problem, can some help me on this.
1. Created a process On Load-Before Header, in which it will be deleting records from temp created
tables, a sample process shown below
BEGIN
IF :P1_TRACKDELHIDD =1
THEN
DELETE FROM PRS.ME_MAIN_WHO
WHERE ATT_SESSION_ID=TO_CHAR(V('APP_SESSION'));
end if;
EXCEPTION WHEN OTHERS THEN
:P1_TRACKDELHIDD:=0;
END;
2. Created a process On Submit-Before Computations and Validations where we are setting the hidden varable as "1" and which we had used
in above mention process, as shown below
:P1_TRACKDELHIDD :=1;
3. Now we have return a main process for application where it will inserts data into master table then delete from tempoary table as shown
below- On Submit-Before Computations and Validations of type"PL/SQL anonymous block "
Begin
INSERT INTO PRS.me_main(part_type,modified_by,created_by)
SELECT part_type,modified_by,V('APP_USER')
FROM PRS.me_main_who
where part_type is not null
and ATT_SESSION_ID=to_char(V('APP_SESSION'));
DELETE from PRS.me_main_who
where ATT_SESSION_ID=to_char(V('APP_SESSION'));
EXCEPTION WHEN OTHERS THEN
RAISE_APPLICATION_ERROR (-20020,'STEP 2:Exception raised during
nsertion into ME Main Form creation');
ROLLBACK;
end;
Thanks & Regards,
SruthiTamiri!!