Repository navigation
cannot use variables on Oracle (through ODBC) #1181
Description
Discussed in #1180
Originally posted by theonewu January 9, 2026
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.
Activity
lovasoa commentedon Jan 12, 2026
@theonewu I just merged the fix, and added continuous testing for oracle. You can test the integration with
lovasoa/sqlpage:mainon docker (should be pushed automatically in a few minutes).