Index: openacs-4/packages/acs-core-docs/www/eng-standards-plsql.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/eng-standards-plsql.html,v diff -u -r1.49.2.10 -r1.49.2.11 --- openacs-4/packages/acs-core-docs/www/eng-standards-plsql.html 21 Jun 2016 07:44:36 -0000 1.49.2.10 +++ openacs-4/packages/acs-core-docs/www/eng-standards-plsql.html 23 Jun 2016 08:32:45 -0000 1.49.2.11 @@ -68,7 +68,7 @@ your PL/SQL code.

  • Name parameters as simply as possible, i.e., use the column name - if the parameter corresponds to a table column. We're deprecating + if the parameter corresponds to a table column. We're deprecating the v_* and *_in syntax in favor of named parameters notation:

     
    @@ -117,7 +117,7 @@
         Use %TYPE and %ROWTYPE whenever possible.
        

  • Use 't' and 'f' for booleans, not the PL/SQL "boolean" datatype - because it can't be used in SQL queries. + because it can't be used in SQL queries.

  • All new functions (e.g., acs_object.new, party.new, etc.) should optionally accept an ID: