I'm a Window user and I have a problem with Oracle SQLLDR.
Whenever I run SQLLDR in CMD, it shows Errors: The code execution cannot proceed because xxx.dll was not found. It pops up several times for some xxx.dll files missing.
I have both instantclient_21_9 and ODAC122011 in my computer. ODAC122011x64 is required by PowerBI to Get data from Oracle database. And I'm still able to connect to Oracle database as well.
I have followed many instructions but they all not work to me. Then I really need your help here. I have download:
- instantclient-basic-windows.x64-21.9.0.0.0dbru.zip
- instantclient-sqlplus-windows.x64-21.9.0.0.0dbru.zip
- instantclient-tools-windows.x64-21.9.0.0.0dbru.zip
from https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
and extract them all in the same directory
I have set PATH in System Variable as below
The ODAC122011\product\12.2.0\client_1 must be above for PowerBI getting data from Oracle Database
I have also tried to remove ODAC from PATH to test, but it's still the same error:
