Oracle PLS-00363:表达式''不能用作分配目标 [英] Oracle PLS-00363: expression '' cannot be used as an assignment target

问题描述

您好，为什么我会收到此错误? 基本上我可以从以下三行中得到它:

Hello not sure why Im getting this error. Basically I get it in these three lines:

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 is an IN parameter. By nature, these are read only. You could define it as an IN OUT parameter, or an OUT parameter.

有关更多信息，请参见此处: http://plsql-tutorial.com/plsql-passing-parameters-procedure-function.htm

For more info see here: http://plsql-tutorial.com/plsql-passing-parameters-procedure-function.htm

这篇关于Oracle PLS-00363:表达式''不能用作分配目标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！