When I paste below PL/SQL code into SQL Execute node in WF, it gives below error during Save process
DECLARE
MYLIST VARCHAR2(4000);
BEGIN
MYLIST := 'asd';
DBMS_OUTPUT.PUT_LINE(MYLIST);
END;
Exact same string executes very well in SQL Developer
Any idea why this could be the case?
The workflow SQL nodes are not intended to provide the full features available from SQL packages.
Specifically you can only include a single SQL statement per node. The statement is not terminated by a semicolon (“;”) that is assumed.
So the example you provided is not meaningful in this context and it is not possible to troubleshoot the individual errors.
Specifically the error (below) that you encountered is generated because local variable assignments cannot be done in workflow SQL nodes using the assignment operator (:=). This feature is just not supported.
SQL Execute : ORA-06550: line 4, column 8: PLS-00103: Encountered the symbol "=" when expecting one of the following: := . ( @ % ; The symbol ":= was inserted before "=" to continue.