Hi All, Its version 19c Oracle. We are experiencing issue while executing a trigger script as below. This trigger is getting created in one of the database and also the ddl is showing those special characters correctly which we see from toad exactly as below. But while executing exact same script in another database , its executed. But while seeing the ddl scripts its showing the special characters all replaced with all square boxes. And copying those to notepad making those question marks. Want to know the cause behind same and how we can fix this issue?
Even we ensured the script file has been saved in UTF8.
CREATE OR REPLACE TRIGGER TRG1 BEFORE INSERT OR UPDATE OF col1 ON TAB1 FOR EACH ROW
DECLARE
xslt XmlType;
BEGIN
xslt := XmlType('
.........................
<xsl:param name="in" Select="''ÂÃÄÀÁÅÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØŠÙÚÛÜÝŸŽàáâãäåçèéêëìíîïñòóôõöøšùúûüýÿž''"/>
........................
</xsl:stylesheet>
');
:new.col1 := :new.col1.transform(xslt);
END;
/