How to call stored procedures

From: <dhinakar_at_my-dejanews.com>
Date: Tue, 20 Apr 1999 20:44:48 GMT
Message-ID: <7fiovv$dlr$1@nnrp1.dejanews.com>

Hi,
I have a problem in calling a stored procedure. I ahve to pass 2 parameters and i ahve to get a cursor as return.

What is the syntax for calling the stored procedure in this situation.

I am using
conn.prepareCall("begin incmgr.p_great_deal.sp_get_title_rvlg(?,?,?);end;");

         call.registerOutParameter(1, OracleTypes.CURSOR);
         call.setString(2,"ROBERT");
         call.setString(3,"18976");

Am I doing right?

Any suggestion?

Thanks.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 15:44:48 CDT