The create or replace the trigger order_b5
Before the insert on order_b
For each row
Declare
DJ varchar2 (3000);
The begin
DJ:=(select price from danjia b where b.i d: new, id and rownum=1);
: new vbdef16:=DJ;
End order_b5;



Error: : PLS - 00103,
Here, there is no problem, but I think I want from other table, values should be how to write?
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

The create or replace the trigger order_b5
Before the insert on order_b
For each row
Declare
DJ varchar2 (3000);
The begin
DJ:='1';
: new vbdef16:=DJ;
End order_b5;

CodePudding user response:

Select the price into the DJ from danjia b where b.i d: new, id and rownum=1;