Hi,
i am facing a problem in oracle web application server. i am creating pl sql cart. and using web packages like HTP,owa_sec. etc well i want to know how can i pass a java script variable holding some value to pl/sql
for example
let us say we have a
create or reeplace procedure anujname
as
begin
htp.p('<script language=javascript>')
htp.p('var mgrname= "Anuj";');
htp</script>');

Now i want to run a sql qery to form the procedure to to find out how many employee are under "Anuj" which is hold in a variable mgrname as metioned above.

please send me some solution if u have or have any idea to do about . i was able to pass the sql variable to javascript variable but vice versa is not possible

thanks and regards
Anuj Chauhan