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:






The rest of the question is being executed and not displayed as is by the browser.