An array of cities? Then why try and bind a cursor type and cast it to a
result set?
Thor HW
----- Original Message -----
From: "Kuklani Mahesh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 19, 2000 1:14 PM
Subject: jsp-servlets
> 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
>
===========================================================================
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
