id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
4140	oracle: manage.py syncdb fails with ORA-06552 when a fieldname is a keyword	frank.hoffsummer@…		"calling ""manage.py syncdb log"" with my log model on an empty Oracle database yields the following exception


{{{
Traceback (most recent call last):
  File ""./manage.py"", line 11, in ?
    execute_manager(settings)
  File ""/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/django/core/management.py"", line 1730, in execute_manager
    execute_from_command_line(action_mapping, argv)
  File ""/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/django/core/management.py"", line 1627, in execute_from_command_line
    action_mapping[action](int(options.verbosity), options.interactive)
  File ""/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/django/core/management.py"", line 573, in syncdb
    cursor.execute(statement)
  File ""/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/django/db/backends/util.py"", line 13, in execute
    return self.cursor.execute(sql, params)
  File ""/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/django/db/backends/oracle/base.py"", line 104, in execute
    return Database.Cursor.execute(self, query, params)
cx_Oracle.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
}}}

the model myapp/log/models.py is simple and causes no problem in MySQL, I attached it to this ticket.
a subsequent, second run of manage py syncdb goes without error.

"	Bug	closed	Database layer (models, ORM)	dev	Normal	invalid	oracle Oracle	Matt Boersma	Unreviewed	0	0	0	0	0	0