Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    20

    Unanswered: Using executeUpdate()

    Hi ,

    I have to lock a row in table TFM069_IMPRT_PROC_CTL . So I am writing the below code in try- catch block and catching the SQLException . Its not throwing SQLException , but i am getting exception as ' null '
    result is of int datatype .


    DatabaseConnect.setOracleConnection();
    Connection lockConn= DatabaseConnect.getConn();
    Statement stmt = conn.createStatement();

    result=stmt.executeUpdate("select execn_ind from tfm069_imprt_proc_ctl " +
    "where imprt_proc_nam='SECRTRNHTF' " +
    "and IMPRT_EVNT_NAM='TFM211_IN_USE'" +
    " FOR UPDATE OF EXECN_IND ");

    Any help is greatly appreciated.

  2. #2
    Join Date
    Sep 2005
    Posts
    20
    I got the solution .. thnks for no reply

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Nirmala,

    The most likely reason you got no reply is that nobody knew the answer. What would you have us do: all reply saying "no idea, sorry"? That would waste everyone's time, including yours...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •