Dear All,
Platform: Windows 2000, Oracle 8i
I am having the following code inside the trigger which is given briefly below,
INSERT INTO ESP_MAT_CONST_OUTPUTS ( BEGIN_DATE, END_DATE, SITE_ID, PROCESS_STREAM_ID, MATCHEM_ID, CONSTITUENT_ID, DAILY_AVG_LIQ_SUR_TEMP_TLA, CONSTITUENT_VAPOR_MOLE_PCT)
SELECT
V.BEGIN_DATE,
V.END_DATE,
V.SITE_ID,
V.PROCESS_STREAM_ID,
V.MATCHEM_ID,
C.CONSTITUENT_ID,
V.DAILY_AVG_LIQ_SUR_TEMP_TLA,
(case when C.CONSTITUENT_VAPOR_WT_PCT Is Null then
(case when V.VP_AT_TLA = 0 then 0 else
GETVP(V.DAILY_AVG_LIQ_SUR_TEMP_TLA,C.CONSTITUENT_ID)*C.CONSTITUENT_MOLE_PCT/V.VP_AT_TLA
end)
FROM ESP_MAT_OUTPUTS V, ESP_MAT_CONSTITUENT C
WHERE V.PROCESS_STREAM_ID = :new.PROCESS_STREAM_ID
AND V.BEGIN_DATE >= :new.BEGIN_DATE
AND V.END_DATE <= :new.END_DATE
AND V.SITE_ID = :new.SITE_ID
AND C.MATCHEM_ID = V.MATCHEM_ID
AND V.DAILY_AVG_LIQ_SUR_TEMP_TLA IS NOT NULL
AND V.VP_AT_TLA IS NOT NULL
AND V.MATCHEM_ID IS NOT NULL;
END;
I get the following error
LINE/COL ERROR
-------- -----------------------------------------------------------------
243/4 PLS-00103: Encountered the symbol "CASE" when expecting one of
the following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
Can anyone please help.
Regards,
cba321
Platform: Windows 2000, Oracle 8i
I am having the following code inside the trigger which is given briefly below,
INSERT INTO ESP_MAT_CONST_OUTPUTS ( BEGIN_DATE, END_DATE, SITE_ID, PROCESS_STREAM_ID, MATCHEM_ID, CONSTITUENT_ID, DAILY_AVG_LIQ_SUR_TEMP_TLA, CONSTITUENT_VAPOR_MOLE_PCT)
SELECT
V.BEGIN_DATE,
V.END_DATE,
V.SITE_ID,
V.PROCESS_STREAM_ID,
V.MATCHEM_ID,
C.CONSTITUENT_ID,
V.DAILY_AVG_LIQ_SUR_TEMP_TLA,
(case when C.CONSTITUENT_VAPOR_WT_PCT Is Null then
(case when V.VP_AT_TLA = 0 then 0 else
GETVP(V.DAILY_AVG_LIQ_SUR_TEMP_TLA,C.CONSTITUENT_ID)*C.CONSTITUENT_MOLE_PCT/V.VP_AT_TLA
end)
FROM ESP_MAT_OUTPUTS V, ESP_MAT_CONSTITUENT C
WHERE V.PROCESS_STREAM_ID = :new.PROCESS_STREAM_ID
AND V.BEGIN_DATE >= :new.BEGIN_DATE
AND V.END_DATE <= :new.END_DATE
AND V.SITE_ID = :new.SITE_ID
AND C.MATCHEM_ID = V.MATCHEM_ID
AND V.DAILY_AVG_LIQ_SUR_TEMP_TLA IS NOT NULL
AND V.VP_AT_TLA IS NOT NULL
AND V.MATCHEM_ID IS NOT NULL;
END;
I get the following error
LINE/COL ERROR
-------- -----------------------------------------------------------------
243/4 PLS-00103: Encountered the symbol "CASE" when expecting one of
the following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
Can anyone please help.
Regards,
cba321