Toad World® Forums

Schema Compare option


#1

Hello,
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.
Current command:

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

Quest.Compare.Schema.Oracle.DBModel


Level 1 inner exception:
ORA-00900: invalid SQL statement

System.Data.OracleClient

"

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.

Thanks,
Paolo


#2

Thanks for the feedback here Paolo,
I have replicated this error in my environment.
We’ll look into this one further!!

Thanks again…
Jaime


#3

CR has been raised for this one…
Definitely a bug!!

Thanks again Paolo…

Jaime