Single-quotes not working in SQL statement run from scheduled SQL*Plus script or PL/SQL script.
I have an Oracle 12.2 multi-tenant database that uses encryption to encrypt a table space. Every night I am required to refresh one of the pluggable databases from a production database. I have been doing that using a simple 'create pluggable database' command from the target CDB that looks like this:
DEVCDB:
create pluggable database DEVPDB1 from PRDPDB1@clone_link keystore identified by 'PassWord1234';
PRDCDB contains the production PRDPDB1 referenced above. The clone_link database link connects to the PRDPDB1 container and creates a copy of it in the DEVCDB container.
That command above has been working perfectly fine for the past year, but after applying the latest January 2019 PSU I get an error due to the single-quotes in the command. I have tried the same command with no single-quotes and using double-quotes. Same error -- It will respond with "invalid password."