Q: jdbc and stored procedures returning several outparameters

From: Trond Kandal <trond.kandal_at_itea.ntnu.no>
Date: Tue, 27 Sep 2005 15:56:38 +0200
Message-ID: <dhbj2n$ihu$1@orkan.itea.ntnu.no>

hello

is there anyone who have used jdbc and stored procedures that returns more than one outparameter?

i have looked at some examples from oracle but they uses only one outparameter.

ex:

CallableStatement cs = conn.prepareCall ("begin ? := foo(?); end;");

cs.registerOutParameter(1,Types.CHAR);
cs.setString(2, "aa");
cs.executeUpdate();

String result = cs.getString(1);

how do i write the code when i want to get more than one outparameter?

thanks!

trond.

-- 
Trond Kandal       Organisasjonsavd. voice: +47 73597497
Integrasjonsgruppa NTNU              mobile:+47 91897110
IT-seksjonen       7491 Trondheim    fax:   +47 73598200
http://www.itea.ntnu.no/integrasjon

This is Unix land.
In quiet nights you can hear M$-Windoze machines reboot.

Received on Tue Sep 27 2005 - 08:56:38 CDT