Welcome, Guest

TOPIC:

Error ORA-00917 MISSING COMMA 6 years 6 months ago #2527

mauro Topic Author Offline Posts: 1	Dear Sirs I'm evaluating the designer product using de Adapters Excel and Oracle, and I got the error ORA-00917 MISSING COMMA, but I can't see where is the cause of error. I also tested the same version usign the adapter Excel and PostgreSQL and I got no error. But, with Oracle I can't solve this error message. Please, helpe me Thank you in advance Mauro Davenia Attachments:
	Please Log in or Create an account to join the conversation.

Error ORA-00917 MISSING COMMA 6 years 6 months ago #2528

FlowHeater-Team
Offline
Posts: 391

Hi Mauro,

I guess this is a bug related to the switch adapter functionality. Could you please try to create a new definition and select the Excel Adapter on the READ and the Oracle Adapter on the WRITE side and try it again? If this works you found a bug, otherwise please post the saved definition file for more analytics.
.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Error ORA-00917 MISSING COMMA 6 years 6 months ago #2529

FlowHeater-Team
Offline
Posts: 391

Hi Mauro,

I think the problem is related to the used field names containing spaces. Currently the Oracle Adapter does not support spaces in field names. I`ve made a short modification, could you please try this Beta Version 4.0.1. Beta4 .

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.