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

Unable to create APP thru oracle table.

 

Hi 

 

I have connected to Gateway

I have connected to our oracle Database successfully.  I am trying to fetch the data from oracle tables

I am able to see some of the tables , But I don't see all the tables here. May I  know the reason.

If I try to search table name  in Custom table column, it gives me error.

 

Please look at the attached error's

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @LohithaSannathi ,

Could you please share a bit more about your scenario?

Do you mean that it could not list all Tables when you create a connection to your Oracle server from your app?

 

Please check if you have typed a proper custom table name when you choose the Table to create connection. Also please check if the all tables that you mentioned belong to same database.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-xida-msft 

 

Could you please share a bit more about your scenario?

 

I am trying to create APP using Oracle Database Connector, When it populates all the tables , I don't see the table which I wanted to select. Please refer the attached screen shot.

 

Do you mean that it could not list all Tables when you create a connection to your Oracle server from your app?

 

yes

 

Please check if you have typed a proper custom table name when you choose the Table to create connection. Also please check if the all tables that you mentioned belong to same database.

 

yes , I tried to enter the table name in Custom table name but it gives me the error, Please refer the screen shot.

Yes they belong to same database

 

I have also seen in the below link there is limit for oracle connector for 150 tables only. Is this True??

 

Oracle Connector table limit 

 

 

Thanks

Lohitha

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,722)