Malformed expression PreCompiler error (PCC-S-02320)

From: Scott <david.albright_at_pncbank.com>
Date: 29 Apr 2002 12:05:13 -0700
Message-ID: <5adbe653.0204291105.78498dc@posting.google.com>

Greetings,

Anyone ran into this problem? Thanks.

I'm developing in Pro*C on a SunOS using Oracle Version 7.3.3
(PreCompiler release 2.2.3.0.0). I am getting the following error
statement:

(1) PCC-S-02320, the declaration of the type of this expression is
incomplete or malformed

I narrowed my code down to a simple test case that follows. Basically, it is generated whenever I use a decode statement within an inbeded SELECT. The following code, and my production code, both run fine from SQL.

SELECT MY_VALUE
FROM (SELECT decode(sign(2-1),-1,1,2) MY_VALUE

FROM dual) Received on Mon Apr 29 2002 - 14:05:13 CDT