Oracle ODBC variable

[theonewu]

when i connect to oracle 11g r2. Use $variable select records.
but the
error returned from database: ODBC emitted an error calling 'SQLExecDirect':
State: HY000, Native error: 902, Message: [Oracle][ODBC][Ora]ORA-00902: no valid datatype.
The SQL statement sent by SQLPage was:
SELECT id,name FROM users WHERE name= CAST(? AS TEXT) ORDER BY id DESC;
student.sql: line 3
oracle 11g r2 has no text datatype.
so i cant continue.

[lovasoa]

Thanks for the report! I'll write a fix. I do not have access to an oracle db, though; would you be available to test the fix?

[theonewu]

OK, I Will.