oracle临时表上触发器,Oracel 10g 中 创建触发器时 临时表是？？？

Oracel 10g 中 创建触发器时  临时表是？？？

CREATE OR REPLACE TRIGGER receivedBook_insert_update

BEFORE INSERT OR UPDATE

ON t_leoa_ReceivedBook

FOR EACH ROW

BEGIN

DECLARE LandNo VARCHAR2(100)

SELECT t_leoa_ReceivedBook.LandInfo_LandNo FROM Dual  -- 临时表

IF LandInfo_LandNo !:= NULL THEN

SELECT LandNo := LandInfo_LandNo FROM t_leoa_BookFlow

WHERE t_leoa_ReceivedBook.LandInfo_LandNo

IF LandNo !:= NULL THEN

UPDATE t_leoa_BookFlow SET LandInfo_LandNo := LandNo+1 WHERE

Flow_ID := (SELECT FLOW_ID FROM t_leoa_BookFlow WHERE LandInfo_LandNo := LandNo)

ELSIF

INSERT INTO t_leoa_BookFlow VALUES(1,FLOW_CURCIRINDEX,FLOW_RECTIME,FLOW_APPLYTIME,

FLOW_REASEARCHTIME,FLOW_FIRSTAUDITTIME,FLOW_BULLETINTIME,FLOW_LASTAUDITTIME,FLOW_REGISTERTIME,

FLOW_SHANZHENGTIME,FLOW_ISSUELANDCERTIFYTIME,FLOW_FTPFOLDERNAME,FLOW_FLAG,LandInfo_LandNo)

END BEFORE ReceivedBook_insert_update;

调试一天还出错 麻烦高手 帮帮忙  多谢啦！！！