You can translate the question and the replies:

Query delegation

Hi, How many columns(fields) I can delegate to the soure from denodo? I am facing an exception 'ORA-01722 invalid number' while delegating more than 160 columns to the source? So is there any limit set on source side or denodo side? Kindly assist, Thanks
11-08-2021 12:39:13 -0400

1 Answer

Hi, Since the error starts with ORA that means that it is being thrown by an Oracle data source not Denodo. Usually the invalid number error is caused by an operation requiring numeric types being done on a non-numeric field/column. So this is likely not related to the number of rows that is being delegated to the source. If you have a valid support user account, please open a new support case at so that the support team can review the issue in detail. Hope this helps!
Denodo Team
12-08-2021 12:43:20 -0400
You must sign in to add an answer. If you do not have an account, you can register here