I have a prepared statement that I need to send to oracle. In this statement there is a WHERE x IN ?
part.
My driver currently does not support lists so I have to implement myself the conversion from my normal data to the data that oracle accepts.
Example: SELECT * FROM table1 WHERE x in ?
and the list []string{"a", "b", "c"}
I tried converting the list of string to several other strings, example {'a', 'b', 'c'}
, ('a', 'b', 'c')
. But they always fail with ORA-01858: a non-numeric character was found where a numeric was expected
.
Does anyone know what the driver might need in order to satisfy a IN clause?
I am writing it in Go but I don't think that matters does it? My data is failing in the oracle database.