when I enable the “SQL*Plus PROMPT comment in Script” option and then I try to run directly the script generated by the Sync wizard, it will end with the following error:
"Fatal error occurred during script execution.
Scripts up to this command have been executed without errors.
Any scripts after this command have not been executed.
Transaction was rolled back.
Prompt DROP VIEW “XXSKU”.“XX_HR_POSTCODE_V” CASCADE CONSTRAINTS;
DROP VIEW “XXSKU”.“XX_HR_POSTCODE_V” CASCADE CONSTRAINTS;
Message: ORA-00900: invalid SQL statement
Level 1 inner exception:
ORA-00900: invalid SQL statement
A reasonable solution could be to disable the possibility to run the script directly in the Sync wizard if that SQL*Plus option is set.