Forum OpenACS Development: Re: Problem with the Oracle database

Collapse
Posted by Rodrigo C on
The second problem was solved with the group by rm.room_id,rm.room_name, thanks Samer; but the original problem is not solved, I get it in a diferent query, look:

Query:
db_multirow reporte foo "select rm.room_name as room_name, pa.email, rv.start_time, rv.end_time, rv.people from reserve rv, rooms rm, parties pa where rv.room_id=$room_id and rm.room_id=rv.room_id and pa.party_id=rv.user_id"

The error:
Database operation "getrow" failed (exception 1406, "nsoracle.c:2055:ora_get_row: error in `OCIStmtFetch ()': ORA-01406: fetched column value was truncated

SQL: [nil]")
    while executing
"ns_db getrow $db $selection"
    invoked from within
"db_getrow $db $selection"
    ("while" body line 4)
    invoked from within
"while { 1 } {

            if { $more_rows_p } {
                set more_rows_p [db_getrow $db $selection]
            } else {
                break..."
    ("uplevel" body line 16)

"Thanks in for your help"
Rodrigo C.

Collapse
Posted by Brian Fenton on
Rodrigo, Sebastiano told you the problem and the answer. You have to change your start_time and end_time TIMESTAMP columns to DATEs. Try it and let us know what happens.

Brian