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      ... View more

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. ... View more

Let me try to load the data in work library & get back to you asap. Thank you very much for your quick response . ... View more

You mean to say , i need to migrate the required tables from MYSql to Oracle and then write a scheduler to perform the activity in scheduled basis. But , i need to write a SAS ETL job to perform this activity . Is there any way to overcome this issue in SAS or at DB level ? ... View more