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.12 -r1.49.2.13 --- openacs-4/packages/acs-core-docs/www/eng-standards-plsql.html 19 Nov 2016 09:21:53 -0000 1.49.2.12 +++ openacs-4/packages/acs-core-docs/www/eng-standards-plsql.html 6 Jan 2017 09:18:41 -0000 1.49.2.13 @@ -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: