This is a tricky error to figure out so I am documenting it here
<class 'cx_Oracle.DatabaseError'> ORA-00932: inconsistent datatypes:
expected - got CLOB
To get this error I had at the bottom of a table definition...
...
auth.signature,
format=IS_UPPER()('%(slug)s'),
migrate=settings.migrate)
Trying to make the slug display as uppercase.
Should just be:
auth.signature,
format='%(slug)s',
migrate=settings.migrate)
Note: This is an *Oracle error*, the web2py book says the IS_UPPER()
function never returns an error. Also note the funky syntax for
IS_UPPER()(argument) is the same as IS_SLUG()(argument)
--
