Hello everyone.
This is a problem that occurs when importing 9i data to the next 12c. For example, there is a field CC#DD in the A table. In the stored procedure, A.CC#DD can be compiled and run. In the case of OLD.CC#DD or NEW.CC#DD in the trigger, there will be compilation errors for invalid characters and bad bind variable , and the double quotes will be written as "CC#DD" and will no longer be an error.
Questions are as follows:
1. Why does the stored procedure not report an error, and the trigger will report an error?
2. The 9i trigger does not use CC#DD with double quotes. Why is there no error?
Thanks