begin
select a.order_percentage,a.bill_percentage
into :csh_payment_terms.order_percentage,
:csh_payment_terms.bill_percentage
from a_csh_payment_terms_add a
where a.payment_term_id =:csh_payment_terms.payment_term_id;
exception when no_data_found then
null;
end ;
-----上面的代码会改变状态
----下面函数手动设置状态为query
set_record_property(:system.trigger_record,:system.trigger_block,status,query_status);
问题解决。