Oracle Database Discussions

Getting following error (trace file content) when querying suing the DB link (select * from "DeviceWindows_Devices"@monolith2.us.oracle.com;)

table: DeviceWindows_Devices
Entered hgopcda at 2012/11/15-18:56:59
Column:1(WindowID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/11/15-18:56:59
Entered hgopcda at 2012/11/15-18:56:59
Column:2(DeviceID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2012/11/15-18:56:59
The hoada for table DeviceWindows_Devices follows...
hgodtab, line 651: Printing hoada @ 0x281a100
MAX:2, ACTUAL:2, BRC:1, WHT=6 (TABLE_DESCRIBE)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
4 INTEGER N 4 4 0/ 0 0 0 0 WindowID
4 INTEGER N 4 4 0/ 0 0 0 0 DeviceID
Exiting hgodtab, rc=0 at 2012/11/15-18:56:59
Entered hgodafr, cursor id 0 at 2012/11/15-18:56:59
Exiting hgodafr, rc=0 at 2012/11/15-18:56:59
Entered hgopars, cursor id 1 at 2012/11/15-18:56:59
type:0
SQL text from hgopars, id=1, len=60 ...
00: 53454C45 43542041 312E5769 6E646F77 [SELECT A1.Window]
10: 49442C41 312E4465 76696365 49442046 [ID,A1.DeviceID F]
20: 524F4D20 44657669 63655769 6E646F77 [ROM DeviceWindow]
30: 735F4465 76696365 73204131 [s_Devices A1]
Exiting hgopars, rc=0 at 2012/11/15-18:56:59
Entered hgoopen, cursor id 1 at 2012/11/15-18:56:59
hgoopen, line 83: NO hoada to print
Exiting hgoopen, rc=0 at 2012/11/15-18:56:59
Entered hgodscr, cursor id 1 at 2012/11/15-18:56:59
Entered hgopcda at 2012/11/15-18:56:59
Column:1(WindowID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
Exiting hgopcda, rc=0 at 2012/11/15-18:56:59
Entered hgopcda at 2012/11/15-18:56:59
Column:2(DeviceID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:0, radix:0
Exiting hgopcda, rc=0 at 2012/11/15-18:56:59
Entered hgopoer at 2012/11/15-18:56:59
hgopoer, line 159: got native error 0 and sqlstate HY092; message follows...
[unixODBC][Driver Manager]Invalid attribute/option identifier
Exiting hgopoer, rc=0 at 2012/11/15-18:56:59
hgodscr, line 456: calling SQLSetStmtAttr got sqlstate HY092
hgodscr, line 506: NO hoada to print
Exiting hgodscr, rc=28500 at 2012/11/15-18:56:59 with error ptr FILE:hgodscr.c LINE:456 FUNCTION:hgodscr() ID:Set array fetch size


Driver : ODBC 5.2(w) Driver
Oracle Database: 11.1.0.7
Mysql Database: 5.5.20

Able to connect from isql and select commands also works fine from there

-bash-3.2$ isql -v monolith_itasmon
---------------------------------------
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
---------------------------------------

Please help in resolving this, thanks in advance.

Thanks,
Vani

Edited by: user580543 on Nov 16, 2012 2:10 AM