Hello Everybody,
In a Custom Event, the content of a variable is automatically filled by the system. This means that, if in a variable there is a single quote, the Action fails.
For example an Event that is fired when the master part is modified and it requires the description.
DECLARE
description_ VARCHAR2(32000) := '&NEW:DESCRIPTION';
...
BEGIN
...
If the description is something like “This is the ‘description’”, the Action fails with an SQL sintax error.
Is it possible to prevent such error ?
Best answer by Charith Epitawatta
View original
