Forum OpenACS Development: Re: Problem with the Oracle database

Collapse
5: Re: Problem with the Oracle database (response to 1)
Posted by Ola Hansson on 05/17/04 09:01 AM
The "!>>>!" in the error message usually points directly to the actual problem.

Maybe try "select rm.room_id,rm.room_name as room_name, ..."?

Collapse
6: Re: Problem with the Oracle database (response to 5)
Posted by Sebastiano Pilla on 05/17/04 10:53 AM
Just a guess, but... You have timestamps (a 9i-feature) columns in your table, but the nsoracle driver doesn't know how to handle them.

What happens if you change the timestamps columns to dates? I don't know if you really need the millisecond-precision that the timestamp datatype has, perhaps the second-precision of the date datatype is enough for you to solve your problem.