Portal Release 2: How to pass variables from PL/SQL to Javascript
Hi,
How can I pass a PL/SQL variable "the_val1 & 2" to a javascript array "message(0)" so that the javascript program can display the value in "the_val1 & 2" on the page. I'm using a dynamic page. Below is a watered-down version of the code:
DECLARE
CURSOR get_my_value IS
SELECT value, at_flag FROM my_tab ;
the_val1 VARCHAR2(4000);
the_val2 VARCHAR2(4000);
BEGIN
FOR i in get_my_value LOOP
IF i.at_flag = 'Y' THEN
the_val1 := i.value;
ELSE
the_val2 := i.value;
END IF;
END LOOP;
END;
My Tab value:
