Clovertech

ODBC Connect 5.3 with Oracle

› Clovertech Forums › Read Only Archives › Cloverleaf › Tcl Library › ODBC Connect 5.3 with Oracle

  • Creator
    Topic
  • August 11, 2010 at 8:16 pm #51928
    LaToya Butler
    Participant

      I’ve written a tcl proc that use the Connect5.3 to read several Oracle tables and kills or continues the message based on the results back from these tables.

    • Creator
      Topic
    Viewing 2 reply threads
    • Author
      Replies
      • August 11, 2010 at 8:36 pm #72335
        David Barr
        Participant

          hstmt not open probably means that there was an error that occurred earlier in the proc.  Maybe there was a problem initializing the driver, connecting to the database or allocating the statement handle.  Are you checking for errors after each of these steps?

        • August 11, 2010 at 8:40 pm #72336
          LaToya Butler
          Participant

            I am checking for SQL_ERROR after each select to the table.

          • August 11, 2010 at 9:20 pm #72337
            Jim Kosloskey
            Participant

              LaToya,

              You need to check to see if each intraction not only the select has functioned.

              I agree with Dave and I suspect the acquisition of your statment handle has failed or not been executed.

              The ODBC drivers from Data Connect can handle much more than the load you are applying (the target DB may be another situation all together).

              email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

          • Author
            Replies
          Viewing 2 reply threads
          • The forum ‘Tcl Library’ is closed to new topics and replies.