When is the Exception thrown in case of Oracle driver when calling a stored procedure

Discussion in 'Java' started by Chads Ford, Aug 16, 2003.

  1. Chads Ford

    Chads Ford Guest

    Hello all, For executing a stored procedure one does something like
    the following:


    CallableStatement cStmt = Connection.prepareCall(sql);
    cStmt.registerOutParameter(parameterIndex,sqlType);
    cStmt.setString("blah");
    cStmt.execute()
    result = cStmt.getString(index);

    Now according to javadoc the Exception can be thrown at either when
    doing the Connection.prepareCall(..) or when doing the
    CallableStatement.execute() and its supposed to be depenedent on the
    driver.

    I am using the Oracle driver from classes111.zip but I can't find in
    the documentation where its supposed to throw the Exception? I think
    it throws it when one does the CallableStatement.execute() and not
    when one does the Connection.prepareCall()

    Can anyone verify this or point to to some document?

    thanks
     
    Chads Ford, Aug 16, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sudhish K V

    Calling Oracle stored procedure using c#

    Sudhish K V, Nov 11, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    6,963
    David Browne
    Nov 11, 2003
  2. =?Utf-8?B?SmltIEhlYXZleQ==?=

    Oracle Calling A Stored Procedure

    =?Utf-8?B?SmltIEhlYXZleQ==?=, Nov 11, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    524
    Jeff Dillon
    Nov 11, 2004
  3. =?Utf-8?B?RGlmZmlkZW50?=

    Calling SYSTEM stored procedure in ORACLE

    =?Utf-8?B?RGlmZmlkZW50?=, May 16, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    422
    =?Utf-8?B?RGlmZmlkZW50?=
    May 16, 2005
  4. =?Utf-8?B?TmVv?=
    Replies:
    2
    Views:
    712
    =?Utf-8?B?TWljaGFlbCBCYWx0aWM=?=
    Jul 12, 2005
  5. websphere
    Replies:
    0
    Views:
    6,679
    websphere
    Aug 25, 2006
Loading...

Share This Page