calling stored procedure

[Donna Reschke]

If I need to call a stored procedure with 6 input parameters and 6 output parameters, how would I do this? Would it look like this?...
cstmt = con.prepareCall("{?, ?, ?, ?, ?, ? = CALL MKTDS22B (?, ?, ?, ?, ?, ?)}");
or this?...
cstmt = con.prepareCall("(CALL MKTDS22B (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,?))" );
Please help! Thanks!

[Jamie Robertson]

this:
assume that in your stored procedure that the first 6 parameters are out parameters and the last 6 are in parameters(note, use curly braces in your prepareCall string):

cstmt = con.prepareCall("[B]{[/B]CALL MKTDS22B (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,?)[B]}[/B]" );

cstmt.registerOutParameter(1, java.sql.Types.VARCHAR);
cstmt.registerOutParameter(2, java.sql.Types.INTEGER);
...
cstmt.registerOutParameter(6, java.sql.Types.VARCHAR);
cstmt.setString(7, "some string");
cstmt.setInt(8, 200145);
...
cstmt.setString(12, "some string");
cstmt.execute();
//process the results.[/code]
Jamie

[prabhatis]

hi, sorry for the late posting . i was busy.
here is the soln,

  
Suppose workpack.getseqnum()is having 4 parameters, first two in and next two r of out type .. the do like this..
//remember to put the procedure name between begin and end  block .. this is the trick
CallableStatement proc = dbCon.prepareCall ("begin workpack.getseqnum(?,?,?,?); end;");
            proc.registerOutParameter(1, Types.VARCHAR);
            proc.registerOutParameter(2, Types.VARCHAR);
            proc.registerOutParameter(3, Types.VARCHAR);
            proc.registerOutParameter(4, Types.NUMERIC);
            //only first two r in parameters so set only those two 
            proc.setString(1,colName);
            proc.setString(2,tName);
//execute
proc.execute();
now u get ur results 
String nextnum =  proc.getString(3);
Strin prevnum = proc.getString(4);