There are some docs/sample code at the oracle website (otn) that came in quite handy when I needed it.
hope it helps - [EMAIL PROTECTED] > -----Original Message----- > From: Mike Jackson [mailto:[EMAIL PROTECTED]] > Sent: 19. �g�st 2002 16:59 > To: Tomcat Users List > Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? > > > I don't think there is one, it'd be really nice if there was > however. There > is some good documentation available from Sun, but it doesn't > get into real > examples (like what you're doing). > > --mikej > -=----- > mike jackson > [EMAIL PROTECTED] > > > -----Original Message----- > > From: Turner, John [mailto:[EMAIL PROTECTED]] > > Sent: Monday, August 19, 2002 9:18 AM > > To: '[EMAIL PROTECTED]' > > Subject: OFF-TOPIC: Pointers to CallableStatement docs? > > > > > > > > Hello - > > > > I think there is a java-user list, or even a jdbc-interest > list, but I'd > > rather not subscribe when all I need is one quick pointer, > so I am hoping > > someone on this list can get me started. > > > > I'm having quite a bit of difficulty working with stored > procedures in my > > classes and servlets. The database is MS SQL Server 2000. I've > > read every > > single doc I can find, both at Sun, through Google, and > even through the > > driver vendor's documentation. I even scammed some code > from a JDBC 3.0 > > book (the only one I could find) at Border's, with still no luck. > > > > Can anyone point me to a resource that explains how to setup stored > > procedures in a CallableStatement correctly? I understand about > > registering > > the output parameters and setting the input types, and I > > understand that the > > parameters in a CallableStatement are numbered from left to > right starting > > at 1. I've seen the examples at Sun, etc. but they're not > much help. > > > > The problem is that all of the examples I can find deal > with very simple, > > very rudimentary stored procedures, like finding the average of > > two numbers, > > or whatever. Our stored procedures are more involved than that. > > > > Example: a stored procedure used to validate logins. It > has 5 input > > parameters, and 5 output parameters. It returns a status. > > According to the > > docs I have read so far, that means I should have a > CallableStatement with > > 11 question marks ("?") in it (5 + 5 + 1 = 11). but that doesn't > > work, and > > I have tried every combination of inputs, outputs, input/outputs, > > etc. that > > I can think of, to no avail. > > > > Any help or pointers to resources that explain stored procedures and > > CallableStatements in more in-depth fashion would be > greatly appreciated. > > > > - John > > > > ============================================ > > John Turner > > [EMAIL PROTECTED] | 248-488-3466 > > Advertising Audit Service > > http://www.aas.com > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
