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

[Sanjana12]

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

[Marcel_Szimonisz]

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

[Sanjana12]

[Marcel_Szimonisz]

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

Marcel

[Craig_Thonis · Accepted solution]

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