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
  • 1098 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

 

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
January 3, 2024

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