You specify your statement as this: String scall = "begin sp_GetClatTypeIE(?, ?); end;";
Which has 2 ?s, but you are only setting the first one: cs.setInt(1, interString); What does your error message say? If this is the problem, Oracle should return something like 'Invalid parameters specified'. --- Neo Gigs <[EMAIL PROTECTED]> wrote: > hi there, > > thanks for the reminder, yet there is no results return as output. I > tried > to replace the line: > > return output; > > with > > return "" + interString; > > and it return my input value... > > ----- Original Message ----- > From: "Karthikeyan .K.V" <[EMAIL PROTECTED]> > To: "Tomcat Users List" <[EMAIL PROTECTED]> > Sent: Saturday, March 09, 2002 12:34 PM > Subject: RE: Help in JSP > > > > Think use the "output=" statement before u use the close > function > > statement. > > > > Karthik > > > > -----Original Message----- > > From: Neo Gigs [mailto:[EMAIL PROTECTED]] > > Sent: Friday, March 08, 2002 9:53 PM > > To: Tomcat Users List > > Subject: Help in JSP > > > > > > Hi there all, > > > > I had a JSP page that talks to a JBeans, but the problem is my Bean > is > > actually doing DB connectivity to a Oracle db, as no result > returned from > > the Bean. > > > > As I had tested with the application of the same codes. > > > > Could anyone help me to scan thru, whats wrong with this? > > > > package com.mbf.beans; > > > > import java.sql.*; > > import java.math.*; > > import java.io.*; > > import oracle.jdbc.driver.*; > > > > public class SpTest > > { > > private int interString; > > private String output; > > > > public String getInput() > > { > > // First detect class existance > > try{ > > Class.forName("oracle.jdbc.driver.OracleDriver"); > > } catch (java.lang.ClassNotFoundException e){ > > System.err.print("Class Not Found error!" + > e.getMessage()); > > } > > > > // Now try to open db connection and do the fetching > > try{ > > // DriverManager.registerDriver(new > > oracle.jdbc.driver.OracleDriver()); > > String url = "jdbc:oracle:thin:@10.97.2.50:1521:REL4"; > > String scall = "begin sp_GetClatTypeIE(?, ?); end;"; > > Connection conn = DriverManager.getConnection(url, > "tux", > > "tux"); > > CallableStatement cs = conn.prepareCall(scall); > > cs.registerOutParameter(2, Types.VARCHAR); > > cs.setInt(1, interString); > > cs.execute(); > > cs.close(); > > conn.close(); > > output = cs.getString(2); > > } catch (SQLException e) { > > System.err.println("Error: " + e.getMessage()); > > } > > return output; > > } > > > > public void setInput(String s) > > { > > // Here to assign input parameters > > interString = Integer.parseInt(s); > > } > > } > > > > Thanks > > > > Regards, > > > > Neo Gigs > > ======== > > VB? > > http://communities.msn.com.my/VisualBasicwithNeo > > http://www.vbcity.com/forum > > http://www.vbweb.co.uk > > Get paid cash receive email? > > http://www.MintMail.com/?m=1414418 > > Reading SMS got paid? > > http://www.dynamicsms.com.au/intro.asp?ref=0123502385&refc=348 > > Malaysianshop.com http://www.malaysianshop.com > > More Traffic? > > http://www.exitblaze.com/cgi-bin/intro_track.pl?b=25924&c=xbad1 > > ================================================ > > Note:This is intended to addressees only, if you wanna be removed, > let me > > know. > > > > > > > > -- > > To unsubscribe: > <mailto:[EMAIL PROTECTED]> > > For additional commands: > <mailto:[EMAIL PROTECTED]> > > Troubles with the list: > <mailto:[EMAIL PROTECTED]> > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
