Hi. I am trying to retrieve data with tOracleInput, and for afterwords process I want to make sure the values are not null. So the query includes NVL functions, making it look like this
"SELECT TABLE.ID, NVL (TABLE.STR '-1') TXT FROM TABLE"
and the schema for tOracleInput is
COLUMN | Db Column | Type | dbType | Nullable ID | ID | Long | NUMBER | No TXT | TXT | String | VARCHAR2 | Yes
With this setting, tOracleInput warns me "schema is different from the query" The input and all the following components work fine, but I would like to get rid of the warning icon if possible.
Hi,
The warning message shows the query is different from the schema, for example, if we define two columns:id and name on the schema, but the query select one or more than two fields like:
"select id, name, age from person"
then, the warning appears. The component always split the query to fields by comma. That's why the warning appears. This warning doesn't affect your job. You can ingnore it if your job works well.
Best regards
Sabrina
