On Fri, Jun 1, 2012 at 11:29 AM, Vinay Sajip <[email protected]> wrote: > I'm getting an error when syncdb tries to execute the following SQL > against Oracle 10g XE: > > CREATE OR REPLACE TRIGGER "ADMIN_CHANGELIST_EVENT_TR" > BEFORE INSERT ON "ADMIN_CHANGELIST_EVENT" > FOR EACH ROW > WHEN (new."ID" IS NULL) > BEGIN > SELECT "ADMIN_CHANGELIST_EVENT_SQ".nextval > INTO :new."ID" FROM dual; > END; > > The error is > > django.db.utils.DatabaseError: ORA-06552: PL/SQL: Compilation unit > analysis terminated > ORA-06553: PLS-320: the declaration of the type of this expression is > incomplete or malformed > > Can anyone suggest what the problem is?
The error is caused by one of the column names in the table. See the second paragraph at: https://docs.djangoproject.com/en/1.4/ref/databases/#naming-issues It's a frustrating error because the column name is perfectly valid, and it has no problem creating the table; it just causes an arbitrary-looking error when you try to create the trigger. Cheers, Ian -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.
