Oracle Database Discussions

Hi,

my Problem is when I join one table from Oracle with one over the hs-DB (Firebird 1.5) I get an error message. The problem exist with every ODBC Driver (Firebird (1.2,2.0 or Easysoft). The newest ODBC-Driver from Firebird should understand ODBC v3 or not? It was definitely working with the old hsodbc-Version of Oracle 9i and the explanation plan looks the same. So I think the failure lies on Oracle.

I've search everywhere for a solution to my problem, but find nothing. I think I'm the only one who's using Oracle in combination with Firebird over ODBC.

More information about config an trace you can find below.

Many thanks for an Answer!!!

Karsten

-------------------------------------
the command:
SELECT pe.NR, us.USER_LOGIN
FROM IBKPVS_SYS_USER us
LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR
where us.USER_LOGIN = 'ADMIN'

ends up in this error msg:

ORA-28500: Verbindung von ORACLE zu Fremdsystem gab diese Nachricht zurück:
[ODBC Firebird Driver]Data truncated[ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -303
conversion error from string " "
ORA-02063: vorherige 4 lines von FORMICA
---------------------------------

Odbc-trace:
...
Entered hgopars, cursor id 1 at 2009/01/09-16:10:27
type:0
SQL text from hgopars, id=1, len=40 ...
00: 53454C45 43542022 4E522220 46524F4D [SELECT "NR" FROM]
10: 20225045 52534F4E 414C2220 57484552 [ "PERSONAL" WHER]
20: 45203F3D 224E5222 [E ?="NR"]
Exiting hgopars, rc=0 at 2009/01/09-16:10:27
Entered hgoopen, cursor id 1 at 2009/01/09-16:10:27
hgoopen, line 83: Printing hoada @ 01EAE650
MAX:1, ACTUAL:1, BRC:1, WHT=3 (BIND_LIST)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
3 DECIMAL N 65 0 0/ 0 0 0 0 ?
Entered hgoprbv at 2009/01/09-16:10:27
hgoprbv, line 122: Printing hoada @ 01EAE650
MAX:1, ACTUAL:1, BRC:1, WHT=3 (BIND_LIST)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
3 DECIMAL N 65 0 0/ 0 0 0 0 ?
Exiting hgoprbv, rc=0 at 2009/01/09-16:10:27
Entered hgopoer at 2009/01/09-16:10:27
hgopoer, line 159: got native error 0 and sqlstate 01004; message follows...
[ODBC Firebird Driver]Data truncated[ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -303
conversion error from string " "
...
--------------------------------

SQL.log (Windows ODBC-Logging) delivers:

dg4odbcFORMICA d8-394 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
..
dg4odbcFORMICA d8-394 ENTER SQLNumResultCols
..
dg4odbcFORMICA d8-394 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
..
dg4odbcFORMICA d8-394 ENTER SQLBindParameter
..
dg4odbcFORMICA d8-394 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
..
dg4odbcFORMICA d8-394 ENTER SQLExecute
..
dg4odbcFORMICA d8-394 EXIT SQLExecute with return code -1 (SQL_ERROR)
..
SQL error code = -303
conversion error from string " " (-303)
--------------------------

Config

initFormica is:

HS_FDS_CONNECT_INFO = FORMICA
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_SUPPORT_STATISTICS=FALSE



listener.ora:
...
(SID_DESC =
(PROGRAM = dg4odbc)
(ORACLE_HOME = C:\oracle\11.1.0\product\11.1.0\db_1)
(SID_NAME = FORMICA)
)
...