Not able to execute SQL script ORACLE

More
4 years 5 months ago #21541 by BPO
Hello,

I am using Visual Importer Enterprise V9.2.9.0 / 64bit

I want execute a SQL query on ORACLE DB but when trying to execute it I have following error (see capture2) of provider seems to be not found. I tested the same query on same DB connection it in the "Run SQL" tab and all work as expected (see capture3).

The connection to this ORACLE DB is working perfectly (see capture) and all other task of extract/load I am doing are working perfectly.

Thanks !
Benjamin
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21542 by admin
Hi Benjamin.

We have reproduced the problem we hope to give you an update next week

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21552 by BPO
Hi Mike,

Thx for the prompt feedback, looking forward to your update.

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21563 by admin
Please try the latest version and let us know the outcome

The changes are

+ Added: Out parameters to reports
- Fixed: Issue with running Oracle SQL scripts from sql script screen

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21565 by BPO
Mike I have updated and the query works well now, but I got an error when scheduling it.
(I have tested executing scheduled task with agent and vimpent, I get the same error for both).

See attached screenshot / I also forwarded vimpent error mail to you.
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #21566 by admin
Looking at it now

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save