summaryrefslogtreecommitdiff
path: root/docs/ref/databases.txt
diff options
context:
space:
mode:
authorMariusz Felisiak <mariusz.felisiak@mga.com.pl>2015-09-15 22:01:31 +0200
committerTim Graham <timograham@gmail.com>2015-09-18 09:50:35 -0400
commita0ce708c1cfa29c13d7334bb27d9c91f570307e8 (patch)
treeb8bdada4b1eb886dac891040b9b2e4f69efed44d /docs/ref/databases.txt
parenteb0bbb8f3a31eb46eb97771cd9c1eccaf01be119 (diff)
[1.8.x] Made assorted improvements to the Oracle documentation.
Backport of 6f1b09bb5c1bafe4633514cbff37f9a7ed7a63ae from master
Diffstat (limited to 'docs/ref/databases.txt')
-rw-r--r--docs/ref/databases.txt16
1 files changed, 9 insertions, 7 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt
index a9308a76a0..bad0a06b98 100644
--- a/docs/ref/databases.txt
+++ b/docs/ref/databases.txt
@@ -762,13 +762,15 @@ for Django's own test suite.
All of these privileges are included in the DBA role, which is appropriate
for use on a private developer's database.
-The Oracle database backend uses the ``SYS.DBMS_LOB`` package, so your user
-will require execute permissions on it. It's normally accessible to all users
-by default, but in case it is not, you'll need to grant permissions like so:
+The Oracle database backend uses the ``SYS.DBMS_LOB`` and ``SYS.DBMS_RANDOM``
+packages, so your user will require execute permissions on it. It's normally
+accessible to all users by default, but in case it is not, you'll need to grant
+permissions like so:
.. code-block:: sql
GRANT EXECUTE ON SYS.DBMS_LOB TO user;
+ GRANT EXECUTE ON SYS.DBMS_RANDOM TO user;
Connecting to the database
--------------------------
@@ -892,10 +894,10 @@ some limitations on the usage of such LOB columns in general:
* LOB columns may not be used in a ``SELECT DISTINCT`` list. This means that
attempting to use the ``QuerySet.distinct`` method on a model that
- includes ``TextField`` columns will result in an error when run against
- Oracle. As a workaround, use the ``QuerySet.defer`` method in conjunction
- with ``distinct()`` to prevent ``TextField`` columns from being included in
- the ``SELECT DISTINCT`` list.
+ includes ``TextField`` columns will result in an ``ORA-00932`` error when
+ run against Oracle. As a workaround, use the ``QuerySet.defer`` method in
+ conjunction with ``distinct()`` to prevent ``TextField`` columns from being
+ included in the ``SELECT DISTINCT`` list.
.. _third-party-notes: