I am using a Java Stored Procedure called MailSend.java which has a method to send email and can take 8 parameters. I deployed the procedure using JDeveloper to Oracle database. It created a procedure called main in the database and a class file under java classes.
Now how do I call the function from a JSP page becuase I can find only one string parameter in the procedure.Pasted below is the procedure:
Please help me in this, I am new to this
PROCEDURE main (p1 IN VARCHAR2) AUTHID CURRENT_USER AS LANGUAGE JAVA NAME 'MailSend.main(java.lang.String)';
Never take anything for granted because you never know when you will lose it
Just like any other stored procedure. Check the JDBC and Oracle documentation for details.
Joined: Aug 26, 2004
Is there any tutorial or documentation in relation to calling a java stored procedure from JSP and Java?
Joined: Oct 12, 2000
read above: there is NO difference between stored procedures written in Java or any other language as far as JDBC is concerned. Check your Oracle documentation for the JDBC driver and a JDBC tutorial on how to use stored procedures. Check a JSP/Servlet tutorial on how to write a JSP page and a servlet. Combine the knowledge you gain from both to write a servlet or JSP page or a servlet that uses stored procedures.