The CREATE OR REPLACE the TRIGGER "HJGOA". "CCC" AFTER INSERT ON "HJGOA". "FORMSON_0589" REFERENCING AS OLD AS "OLD" NEW "NEW" FOR EACH ROW
DECLARE
XmbhS varchar (50);
- mainid varchar (50);
Cursor cur_usercode (XMBH VARCHAR (50)) is the select id from formmain_0640 where field0005=XMBH;
The begin
The SELECT field0005 INTO XMBHS from FORMMAIN_0588 where id=: NEW. Formmain_id;
For dept_row cur_usercode in loop (XMBHS)
Insert into FORMSON_0886 (dept_row. ID, field0030 field0031, field0032, field0033) VALUES (mainid, : NEW field0008, : NEW field0009, : NEW. Field0010, : NEW. Field0015);
end loop;
END
ALTER the TRIGGER "HJGOA". "CCC" ENABLE


Using the cursor, oracle has been prompt invalid SQL statements, rookie, a problem may be low, but there is no way, o god,

CodePudding user response:

Field problem I noticed, changed or not

CodePudding user response:

You trigger did not name

CodePudding user response:

Name in double quotation marks?

CodePudding user response:

What is mainid, annotation defined

CodePudding user response:

CREATE the TRIGGER..

END; - add a semicolon here

CodePudding user response:

reference 5 floor selling fruit net reply:

CREATE TRIGGER..

END; - add a semicolon here

semicolon, or not

CodePudding user response:

reference jovien reply: 3/f

name in double quotation marks?

create a trigger is tool to generate statements

CodePudding user response:

"HJGOA". The name "CCC" oh, right

CodePudding user response:

The

8/f, 530303869 references reply:

"HJGOA". The name "CCC" right oh

this should be no problem, is a tool to generate

CodePudding user response:

The CCC this object does not exist, is sure lower case?

CodePudding user response:

references to the tenth floor selling fruit net reply:

that is CCC this object does not exist, is sure lower case?

yes, sure is lowercase

CodePudding user response:

The CREATE OR REPLACE the TRIGGER "HJGOA". "CCC" AFTER INSERT ON "HJGOA". "FORMSON_0589" REFERENCING AS OLD AS "OLD" NEW "NEW" FOR EACH ROW
DECLARE
XmbhS varchar (50);
- mainid varchar (50);
Cursor cur_usercode (XMBH VARCHAR (50)) is the select id from formmain_0640 where field0005=XMBH;
The begin
The SELECT field0005 INTO XMBHS from FORMMAIN_0588 where id=: NEW. Formmain_id;
For dept_row cur_usercode in loop (XMBHS)
Insert into FORMSON_0886 (dept_row. ID, field0030 field0031, field0032, field0033) VALUES ( mainid , : NEW field0008, : NEW. Field0009, : NEW. Field0010, : NEW. Field0015);
end loop;
END
ALTER the TRIGGER "HJGOA". "CCC" ENABLE