DbUtils doesn't contain direct support for stored procedures so it's
probably easier to deal with them manually. Contributions are always
welcome though!
David
--- Norris Shelton <[EMAIL PROTECTED]> wrote:
> I want to call something like this:
>
> CallableStatement pstmt = conn.prepareCall("{call
> p_highest_paid_emp(?,?,?,?)}");
> pstmt.setInt(1, i_deptno);
> pstmt.registerOutParameter(2, Types.INTEGER);
> pstmt.registerOutParameter(3, Types.VARCHAR);
> pstmt.registerOutParameter(4, Types.FLOAT);
> pstmt.executeUpdate();
>
> int o_empno = pstmt.getInt(2);
> String o_ename = pstmt.getString(3);
> float o_sal = pstmt.getFloat(4);
>
> The last 3 parameters are output parameters.
>
> =====
>
> Norris Shelton
> Software Engineer
> Sun Certified Java 1.1 Programmer
> Appriss, Inc.
> ICQ# 26487421
> AIM NorrisEShelton
> YIM norrisshelton
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
