Hi,
I want to use collections in my code . Can anybody point out the problem
with the following code. I am getting an SQLException
SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types
of arguments in call to 'GET_DATA' ORA-06550: line 1, column 7: PL/SQL:
Statement ignored
call = con.prepareCall("{ call
wss_citylist.get_data(?,?,?) }");
call.setString(1,"13-APR-00") ;
call.setString(2,"20-APR-00") ;
call.registerOutParameter(3,OracleTypes.CURSOR) ;
call.execute();
rs1 = (ResultSet)call.getObject(3) ;
where wss_citylist is a oracle stored procedure and takes three parameters
such as arrival date, departure date and third one is an array of cities.
Thanks in advance.
Mahesh.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
