Hi, we are trying to import a csv file into Campaign and getting invalid syntax error. Please help
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
Views
Replies
Total Likes
Views
Replies
Total Likes
Ah okey. It says invalid character. Maybe encoding issue. try to encode the file in utf 8 before adding data?
Marcel
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