I have a main form where I have a field SYUS_ID_PM I want to update it with the value from a field P7_Osoba from another modal form opened with a button from the main form. I have defined dynamic action Deleguj with Action Set Value and I try a code for Set Type PL/SQL Expression:
BEGIN
update projects2 set SYUS_ID_PM = :P7_OSOBA;
end;
However this results in an error:
- ORA-06550: line 1, column 114: PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set s
What can I do to fix this error?