Changes between Initial Version and Version 1 of Ticket #17932, comment 9


Ignore:
Timestamp:
Jun 2, 2012, 7:11:02 AM (13 years ago)
Author:
Vinay Sajip

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #17932, comment 9

    initial v1  
    11Reopened, as the problem is still occurring. I'm getting an error when syncdb tries to execute the following SQL against Oracle 10g XE:
    2 
     2{{{
    33CREATE OR REPLACE TRIGGER "ADMIN_CHANGELIST_EVENT_TR"
    44BEFORE INSERT ON "ADMIN_CHANGELIST_EVENT"
    … …  
    99        INTO :new."ID" FROM dual;
    1010    END;
    11 
     11}}}
    1212The error is
    13 
    14 django.db.utils.DatabaseError: ORA-06552: PL/SQL: Compilation unit
    15 analysis terminated
    16 ORA-06553: PLS-320: the declaration of the type of this expression is
    17 incomplete or malformed
    18 
     13{{{
     14django.db.utils.DatabaseError: ORA-06552: PL/SQL: Compilation unit analysis terminated
     15ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed
     16}}}
    1917This time it's due to a column named 'date', and just to confuse things further, the column name is accepted for the table creation itself, but fails for the trigger creation. Adding "db_column='event_date'" to the relevant model definition caused the failure to disappear.
Back to Top