cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Error connecting to Oracle DB

Hello,

 

I am trying to retrieve some data from an Oracle DB through Flows and followed the steps mentioned here: https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-log...

 

I installed a Gateway and got help in installing an Oracle client on the same server where the gateway resides. Now when i create a flow and try to setup the Oracle connection, i get an error as below:

 

Oracle Error.PNG

 

This is the error message:

Test connection failed. Details: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' inner exception: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' clientRequestId: 7F4B5640-CF33-421B-A57A-E39F8E55E3C1

 

Verified the Oracle client works too. But is there any step i am missing? Would be of great help if someone could share the step by step process if what i followed is not right. Thanks in advance.

 

Regards,

Nithin

3 REPLIES 3
Microsoft
Microsoft

Hello @Nithin_Vanam 

What is the authentication type you have in the list. Change it accordingly .It should work.

 

Thanks

@pre , the only authentication i see is Basic. There are no other options displayed. 

Hello @Nithin_Vanam 

Please check if you can log into Oracle POC server seperately , using the username and password which you used to connect here . What other options you see other than Oracle POC , share me the information.

Check these links and make sure the oracle connection is established as expected::
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-oracledb
https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-log...

Thanks

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (100,901)