Forum OpenACS Development: Re: Problem with the Oracle database

Collapse
Posted by Ola Hansson on
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
Posted by Sebastiano Pilla on
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.