Precompilers and OCI (MOSC)

MOSC Banner

What's wrong:PCC-S-02201 while trying "UPDATE VOARESS r set NUTZUNG_STATUS_SL=NVL((select 1 from voa

edited Apr 18, 2013 10:30PM in Precompilers and OCI (MOSC) 3 commentsAnswered
Pro*C/C++: Release 11.1.0.7.0  AIX 6.1

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center