on submit (button) calling a JS function in a PL/SQL process
590947Aug 14 2007 — edited Sep 27 2007Hi,
I have a JS function call(); defined in Page HTML Header. I have a 'submit' button which should excecute the following process on submit:
DECLARE
v_Status char(5):= 'RSEND';
BEGIN
htp.p('<html>');
IF (APEX_APPLICATION.G_F01.COUNT < 1) THEN
htp.p('<script type="text/javascript">');
htp.p('call();');
htp.p('</script>');
htp.p('</html>');
ELSE
FOR ii IN 1 .. APEX_APPLICATION.G_F01.COUNT
LOOP
UPDATE NI SET NI.STATUS_NI = v_Status WHERE NI.NI_REF = APEX_APPLICATION.G_F02(APEX_APPLICATION.G_F01(ii));
END LOOP;
END IF;
END;
But, the above process is not working. When I click the button the page is getting submitted but the alert is not coming up though I did not select any record.
Can anyone put some light on this?
Thanks and Regards,
Antara