Open Cursors in Forms 4.0

From: Adrian Wilson <awilson_at_intermec.com>
Date: 29 Jul 94 14:53:44 GMT
Message-ID: <2694_at_intermec.UUCP>

>I've created a form with Oracle Forms 4.00. There are many buttons that take
>you to different canvases all containing one or more blocks. After testing
>out the form I found that if you keep going to different windows Forms starts
>popping up errors because it's out of cursors. How can I close these cursors
>after I have left a canvas and no longer need to remember what record I was
>on in that canvas's block?
>
>Can I close the cursors? Or what is the proper method for dealing with this?
>Currently the Oracle database has OPEN_CURSORS set to 50.
>
>
>Thanks,
>Anil

Would bumping your cursors up be a consideration. We had an application that had the same problem and bumping the the open cursors to 75 fixed it.

Adrian Wilson
Seattle, Washington

    //      //  //    //  //////  ///////   //////    ///////   ////////
   //      //  ////  //  //      //    // //     //  //        //
  //      //  // // //  //      ///////  //     //  ////////  /////////
 //      //  //  ////  //      //    // //     //        //         //

/////// // // // /////// // // ////// /////// ////////    Received on Fri Jul 29 1994 - 16:53:44 CEST