Index: openacs-4/packages/acs-core-docs/www/eng-standards-plsql.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/eng-standards-plsql.adp,v diff -u -r1.1.2.7 -r1.1.2.8 --- openacs-4/packages/acs-core-docs/www/eng-standards-plsql.adp 6 Jan 2017 09:18:41 -0000 1.1.2.7 +++ openacs-4/packages/acs-core-docs/www/eng-standards-plsql.adp 21 Apr 2017 15:07:52 -0000 1.1.2.8 @@ -83,7 +83,7 @@ acs_user.create(first_names_in => 'Jane', last_name_in => 'Doe', etc.) -

To achieve this we must fully qualify arguements passed into +

To achieve this we must fully qualify arguments passed into procedures or functions when using them inside a SQL statement. This will get rid of any ambiguities in your code, i.e. it will tell the parser when you want the value of the column and when you @@ -129,7 +129,7 @@ ) return acs_objects.object_id%TYPE;

takes the optional argument object_id. Do this to allow people to use the same API call when they are doing double click protection, that -is, tehy have already gotten an object_id and now they want to create the +is, they have already gotten an object_id and now they want to create the object with that object_id.