topic Re: Oracle Database - Unable to view the Input columns for Inser/Upsert/Update Actions in Workato Pros Discussion Board

Oracle Database - Unable to view the Input columns for Inser/Upsert/Update Actions

pavan-narayan — Tue, 13 Aug 2024 10:55:26 GMT

Hi All,

I am trying to insert rows in the Oracle table and was unable to see the input column names

1.I haven't selected the table from the drop down list instead I have passed the Table Name .
2.Post saving the table name it was not giving the input columns for me to map any.
3. The user already have RW access aswell .
4. I have tried passing the Run custom SQL query and then able to execute and have no issues.
5.Not sure why when entering the table name it was populating the Input fields to map.

Any one had this issue before ??

Re: Oracle Database - Unable to view the Input columns for Inser/Upsert/Update Actions

juliana-recio — Mon, 09 Sep 2024 11:25:41 GMT

Hi, @pavan-narayan!

This issue happens when you have entered an incorrect table name.

Here's an example of an invalid table name:

Vs. a valid table name :

Make sure to enter the correct value. Table name is case-sensitive for some databases. You can use this action to check if the table is correct.

Re: Oracle Database - Unable to view the Input columns for Inser/Upsert/Update Actions

pavan-narayan — Tue, 10 Sep 2024 04:49:50 GMT

Hi @juliana-recio ,

Thanks for the reply ,Later I have realized that the table name is Case-Sensitive that caused the issue. Later it has been sorted.