您好不确定我为什么收到此错误。基本上我可以从以下三行中得到它:
PLS-00363: expression 'p_temp_foo.editable.modified_by' cannot be used as an assignment target PLS-00363: expression 'p_temp_foo.editable.date' cannot be used as an assignment target PLS-00363: expression 'p_temp_foo.editable.modified_by' cannot be used as an assignment target
程序:
PROCEDURE run_temp_procedure (p_temp_foo IN part_bean, p_member_number IN NUMBER) IS t_temp_foo part_bean; now DATE; BEGIN now := SYSDATE; p_temp_foo.editable:= t_temp_foo.editable; p_temp_foo.editable.date := SYSDATE; p_temp_foo.editable.modified_by := p_member_number; END run_temp_procedure ;
p_temp_foo是一个IN参数。本质上,它们是只读的。您可以将其定义为IN OUT参数或OUT参数。
p_temp_foo
IN
IN OUT
OUT
有关更多信息,请参见此处:http : //plsql-tutorial.com/plsql-passing-parameters- procedure-function.htm