What's wrong:PCC-S-02201 while trying "UPDATE VOARESS r set NUTZUNG_STATUS_SL=NVL((select 1 from voa
Instance: 11.2.0.3 PSU5 on AIX 6.1
We get always
UPDATE VOARESS r set NUTZUNG_STATUS_SL=NVL((select 1 from voaresu u), 0);
..................................................1
PCC-S-02201, Encountered the symbol "1" when expecting one of the following:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
when trying this Statement:
UPDATE VOARESS r set NUTZUNG_STATUS_SL=NVL((select 1 from voaresu u), 0);
in Pro*C. Also following statement fails with error
EXEC SQL EXECUTE
BEGIN
UPDATE VOARESS r set NUTZUNG_STATUS_SL=NVL((select 1 from voaresu u), 0);
END;
END-EXEC;
Have you any idea what's wrong? How can i parse the statement without error?
Thanking in advance