Oracle Clob Field type

226 views
Skip to first unread message

chaka....@gmail.com

unread,
Nov 5, 2008, 5:54:03 PM11/5/08
to Django users
Noob here...

I have an existing table with two Clob fields. While defining the
model I use TextField as the filed type.

running <python manage.py syncdb> gives me back the error:

cx_Oracle.DatabaseError: ORA-01754: a table may contain only one
column of type LONG

Well, what I really want are clobs to begin with. It sounds like what
I really want to do is subclass Field, but this is starting to turn in
to more trouble than it's worth...

This has to be something somebody's come across before.

Karen Tracey

unread,
Nov 5, 2008, 9:06:40 PM11/5/08
to django...@googlegroups.com

I've no experience with Oracle but -- you run syncdb to create your tables.  If you already have the table, why are you running syncdb?

Karen

Ian

unread,
Nov 6, 2008, 11:09:21 AM11/6/08
to Django users
On Nov 5, 3:54 pm, "chaka.ben...@gmail.com" <chaka.ben...@gmail.com>
wrote:
Django doesn't use LONG columns. Please make sure that you're using
Django 1.0+ and *not* a 0.96 release. The oracle backend included in
0.96 was incomplete and should not be used.

Hope that helps,
Ian

chaka....@gmail.com

unread,
Nov 7, 2008, 10:35:19 AM11/7/08
to Django users
You're right -- there's no need to run syncdb. All of this is a
learning exercise for me.
I'm just running the commands to see the output and behavior as I go
through the docs, with an eye for potential snags and "gotchas" that
might kill me later on.




On Nov 5, 9:06 pm, "Karen Tracey" <kmtra...@gmail.com> wrote:
> On Wed, Nov 5, 2008 at 5:54 PM, chaka.ben...@gmail.com <
Reply all
Reply to author
Forward
0 new messages