I have a situation where i need to make a asynchronous ps/sql stored proc. call from my JSP page (I just have JSP pages in the APP). When the user clicks on a link (hyperlink1.jsp), this pl-sql call must be made and then the hyperlink1.jsp should be executed. I can think of the following three ways to do this. 1) Using ajax, send a request to make the pl/sql call and immediately forward to hyperlink1.jsp 2) in hyperlink1.jsp, create a new thread and make the pl/sql call. 3) create a table in DB add a trigger to it which calls the pl/sql stored proc. hyperlink1.jsp inserts a row in this table.
Yes, i have JDBC code in a JSP. I am making changes to Oracle Apps e-business suite. the code is almost 8-10 years old. I know i should use a servlet, but the entire application is written in JSPs. This is required for client specific customization.
permaculture is giving a gift to your future self. After reading this tiny ad: