Hi Mahesh,
I think there are something wrong with your procedure.
Your procedure should looks like that:
In the wss_citylist package spec:
type cur is ref cursor;
procedure get_data(var_adate in varchar2, var_ddate in varchar2
, mycursor out cur);
In the wss_citylist package body:
procedure get_data(var_adate in varchar2, var_ddate in varchar2
, mycursor out cur)
is
begin
open mycursor for
select .. from ..where ..var_adate...var_ddate ;
end;
xgh
----- Original Message -----
From: Kuklani Mahesh
To: [EMAIL PROTECTED]
Sent: Tuesday, June 20, 2000 04:14 AM
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
