09-29-2008 09:04 AM
I need help Fetching data from an Oracle Database. Originally my code was Fetching data from a MySQL database. We are migrating from MySQL to Oracle. My code works for the MySQL database and for the most part works for the Oracle database. The only problem I have when running the Oracle database, it seems the database application hangs when attempting to close the application. The CPU useage spikes up to 50%. The application will not close on it's own an you have to use Task Manager to close the application. I susptect the application is hanging at the Fetch loop.
Please find attached my code. Please excuse the "test code". I have also included the tnsnames.ora file for my setup.
09-30-2008 01:43 PM
Hello,
I just wanted to post to let other customers know what we already talked about on the phone, which is that this is a known issue with the CVI SQL Toolkit that was corrected in version 2.1.
I believe you are downloading the latest versions of CVI and the SQL toolkit, please let me know by phone, email, or forum how that goes.