- Posts: 139
- Thank you received: 5
VI Not Reading Oracle DB
1 month 3 weeks ago #22886
by MikeG
VI Not Reading Oracle DB was created by MikeG
I changed the TNS names to connect to the Test database to troubleshoot an issue. It shows connected when I test. However, it isnt reading the Test database, and is not returning any results
. If I paste the same Import script into PLSQL Developer, it returns the correct results. I am using VMPRO64, version 9.2.7.14.
Please Log in or Create an account to join the conversation.
1 month 3 weeks ago - 1 month 3 weeks ago #22887
by admin
Mike
ETL Architect
Replied by admin on topic VI Not Reading Oracle DB
Perhaps it is connected to the wrong database
You can check it by running
You can check it by running
Code:
SELECT host_name
FROM v$instance
or
Code:
select sys_context('USERENV','SERVER_HOST') from dual
Mike
ETL Architect
Last edit: 1 month 3 weeks ago by admin.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
1 month 3 weeks ago #22891
by MikeG
Replied by MikeG on topic VI Not Reading Oracle DB
The database seems correct
Please Log in or Create an account to join the conversation.
1 month 3 weeks ago #22893
by MikeG
Replied by MikeG on topic VI Not Reading Oracle DB
I did the same in PLSQL, and it's reading the same DB
Please Log in or Create an account to join the conversation.
