Unable to import list in Campaign. ORA-00911: invalid syntax | Community
Skip to main content
Level 6
January 2, 2024
Solved

Unable to import list in Campaign. ORA-00911: invalid syntax

  • January 2, 2024
  • 1 reply
  • 1097 views

Hi, we are trying to import a csv file into Campaign and getting invalid syntax error. Please help

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

Hi Sanjana,

From the error, it looks like you may be missing a closing single quote. I can see one before the CREATE but not at the end, though this may be just cut off from the screenshot.

Additionally, based on Oracle documentation, it seems like spaces may not be allowed unless enclosed in double quotes. From the logs, it does look like there may be leading spaces that need to be removed.

https://docs.oracle.com/en/error-help/db/ora-00911/

Regards,

Craig

1 reply

Marcel_Szimonisz
Community Advisor
Community Advisor
January 2, 2024

Hello @sanjana12,
How do you get syntax error for workflow activity? You only get it when you have script in the intialization tab? can you share the error message?

 

Marcel

Sanjana12Author
Level 6
January 3, 2024

 

Marcel_Szimonisz
Community Advisor
Community Advisor
January 3, 2024

Ah okey. It says invalid character. Maybe encoding issue. try to encode the file in utf 8 before adding data?

 

Marcel