Loading data from MySQL to Oracle in DI studio in table loader Transformation , I am getting this ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]Fetch without a SELECT
I tried looking it up, and the problem seems to come (sporadically) with the ODBC connection to MySQL (not just in SAS, the problem seems to have nothing to do with SAS). If possible, you should switch to the SAS Interface to MySQL, instead of going through ODBC.
No, you do not need to migrate the required tables. I think the solution is to use an interface to MySQL that does not go through ODBC, as that seems to be the one creating the problems. So, if you have access for MySQL, you may want to try that instead of the ODBC interface, as suggested here.
Does reading the MySQL table into a SAS dataset work reliably? You could do the load via an intermediate SAS table.
I tried to load the data in work Library,but I am getting the same ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]Fetch Without Select.
Does the source MySQL table physically exist? Can you access it by any other means?
Hi Patrik,
Thanks for your response.
Does the source MySQL table physically exist?
The MySQL DB is on cloud .
Can you access it by any other means?
Through public IP we are accessing the DB server.
Note:
We have migrated the data to oracle DB . Now we are doing some ETL activity on the same data & again loading the data to another oracle table , at table loader transformation we are facing the below mentioned error.
Error: CLI CURSOR FETCH ERROR , FETCH WITHOUT A SELECT
I've used in the past DIS with Oracle quite a bit but never with ODBC but the native SAS/Access to Oracle engine. If you have this engine licensed then ideally switch to using it.
I assume the issue is somewhere with the ODBC driver version. I suggest you raise a track with SAS Tech Support.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: