I got the message Error at line 31: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
This is my trigger:
create or replace TRIGGER add_fiscaly
AFTER INSERT ON MDW_SCRAP_MDCOPY
FOR EACH ROW
BEGIN
SELECT PR\_YEAR||PR\_MONTH
INTO :NEW.Fiscaly
from
(SELECT
CASE EXTRACT (MONTH FROM SYSDATE)WHEN 1 THEN EXTRACT(YEAR FROM SYSDATE)-1
WHEN 2 THEN EXTRACT(YEAR FROM SYSDATE)-1
WHEN 3 THEN EXTRACT(YEAR FROM SYSDATE)-1
ELSE EXTRACT(YEAR FROM SYSDATE)
END
AS PR\_YEAR ,
CASE EXTRACT (MONTH FROM SYSDATE)
WHEN 04 THEN 1
WHEN 05 THEN 1
WHEN 06 THEN 1
WHEN 07 THEN 1
WHEN 08 THEN 1
WHEN 09 THEN 1
WHEN 10 THEN 2
WHEN 11 THEN 2
WHEN 12 THEN 2
WHEN 01 THEN 2
WHEN 02 THEN 2
WHEN 03 THEN 2
END
AS PR\_MONTH
FROM dual)
END;
/
The line 31 is: AS PR_MONTH
I'd appreciate your help