SQL & PL/SQL

All,

The following query works.

SELECT
TABLE1.FIELD1,
CAST(
TABLE2.FIELDMULTIPLIER2 *
CASE
WHEN TABLE1.FIELDCHECK=1
THEN TABLE1.FIELD2 * TABLE3.SOMETYPEOFDECIMAL
ELSE TABLE1.FIELD2
END AS NUMBER(17,7)) AS FIELD2,
CAST(
TABLE2.FIELDMULTIPLIER3 *
CASE
WHEN TABLE1.FIELDCHECK=1
THEN TABLE1.FIELD3 * TABLE3.SOMETYPEOFDECIMAL
ELSE TABLE1.FIELD3
END AS NUMBER(17,7)) AS FIELD3
FROM TABLE1
INNER JOIN TABLE2
ON TABLE1.FKTABLE2 = TABLE2.ID
INNER JOIN TABLE3
ON TABLE1.FKTABLE3 = TABLE3.ID.

However, when I try to put this into a View, I get an Unexpected token near *!* in the following: END AS NUMBER(17*!*,7)) AS FIELD2 and Unexpected token near *!* in the following: END AS NUMBER(17,7*!*)) AS FIELD2. The query executes fine, but when I test the syntax I get this error and the view doesn't compile.

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

Edited by: 929933 on Mar 11, 2013 5:18 PM