cancel
Showing results for 
Search instead for 
Did you mean: 

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

pavan-narayan
Deputy Chef III
Deputy Chef III

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 ?? 

 

Capture.PNG




1 ACCEPTED SOLUTION

pavan-narayan
Deputy Chef III
Deputy Chef III

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.

View solution in original post

2 REPLIES 2

juliana-recio
Workato employee
Workato employee

Hi, @pavan-narayan!

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

Here's an example of an invalid table name:

Screenshot 2024-09-09 at 7.15.14 PM.png

Vs. a valid table name :

Screenshot 2024-09-09 at 7.19.52 PM.png

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. 

Screenshot 2024-09-09 at 7.21.48 PM.png

pavan-narayan
Deputy Chef III
Deputy Chef III

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.