0 Replies Latest reply on Jul 3, 2006 3:28 PM by 521310

    TimeOut on inserting

    521310
      Hi,
      I have a VB program working with OO4O.
      I have a table1 in Oracle10g that contains a before insert trigger. This trigger do a "update table2...."
      The VB application executes an "insert into table1(...) values(...)"
      My problem is when table2 is locked then, my VisualBasic application freezes.
      I need that the application shows an error if insert can't terminated after 3 seconds.
      Can I define a timeout or something similar?
      Thanks.

      Juan Carlos