[vwnc] ODBC access violation when reading Oracle table
Locked
[vwnc] ODBC access violation when reading Oracle table
 
|
Hi I noticed that if I attempt to read an Oracle table, via
ODBC, that has a column defined as a non-standard data type I get an exception. Using Oracle 9i I connected as SYSTEM and using ad-hoc sql I
executed ‘select * from AQ$_QUEUES’ and got SystemError(#'exception
occured',#(3221225477 35570678)). It works ok for ‘select * from AQ$_QUEUE_TABLES’. I have the latest Oracle ODBC drivers installed. When I execute the same expression against a 10g database I also get an exception SystemError(#'exception
occured',#(3221225477 1640673393)). Terry _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Re: [vwnc] ODBC access violation when reading Oracle table
|
|
A little additional info; I tried the same thing only connecting via
the OracleEXDI and instead of an exception I got an Oracle error. ORA-24359: OCIDefineObject not invoked for
a Object type or Reference This is using vw 7.6. Terry From: Terry Raymond
[mailto:[hidden email]] Hi I noticed that if I attempt to read an Oracle table, via
ODBC, that has a column defined as a non-standard data type I get an exception. Using Oracle 9i I connected as SYSTEM and using ad-hoc sql I
executed ‘select * from AQ$_QUEUES’ and got
SystemError(#'exception occured',#(3221225477 35570678)). It works ok for ‘select * from
AQ$_QUEUE_TABLES’. I have the latest Oracle ODBC drivers installed. When I execute the same expression against a 10g database I
also get an exception SystemError(#'exception
occured',#(3221225477 1640673393)). Terry _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Re: [vwnc] ODBC access violation when reading Oracle table
|
|
Sorry about this late response. I don’t
think the exdi is set up to work with user defined types. In 1998 we had an
interface for Oracle’s then new object technology, which includes user
defined types. But Oracle seems to have quietly backed away from that product
line, and I don’t think we actually shipped and supported it. From what I
recall, the api was fairly cumbersome. Anyway, that’s just my hunch about
what’s going on. My 10g server doesn’t have the tables you
mentioned. - Dave From:
[hidden email] [mailto:[hidden email]] On Behalf Of Terry Raymond A little additional info; I tried the same thing only connecting via
the OracleEXDI and instead of an exception I got an Oracle error. ORA-24359: OCIDefineObject not invoked for
a Object type or Reference This is using vw 7.6. Terry From: Terry Raymond
[mailto:[hidden email]] Hi I noticed that if I attempt to read an Oracle table, via
ODBC, that has a column defined as a non-standard data type I get an exception. Using Oracle 9i I connected as SYSTEM and using ad-hoc sql I
executed ‘select * from AQ$_QUEUES’ and got
SystemError(#'exception occured',#(3221225477 35570678)). It works ok for ‘select * from
AQ$_QUEUE_TABLES’. I have the latest Oracle ODBC drivers installed. When I execute the same expression against a 10g database I
also get an exception SystemError(#'exception occured',#(3221225477
1640673393)). Terry _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Re: [vwnc] ODBC access violation when reading Oracle table
|
|
Dave The table is one of the default tables
created when you create a new database the simple way. Any suggestions? I suspect that more and
more databases will be using the datatypes and not being able
to read the tables will put VW applications at a disadvantage. Terry From: Wallen, David
[mailto:[hidden email]] Sorry about this late response. I
don’t think the exdi is set up to work with user defined types. In 1998
we had an interface for Oracle’s then new object technology, which
includes user defined types. But Oracle seems to have quietly backed away from
that product line, and I don’t think we actually shipped and supported it.
>From what I recall, the api was fairly cumbersome. Anyway, that’s just my hunch about
what’s going on. My 10g server doesn’t have the tables you
mentioned. - Dave From:
[hidden email] [mailto:[hidden email]] On Behalf Of Terry Raymond A little additional info; I tried the same thing only connecting via
the OracleEXDI and instead of an exception I got an Oracle error. ORA-24359: OCIDefineObject not invoked for
a Object type or Reference This is using vw 7.6. Terry From: Terry Raymond
[mailto:[hidden email]] Hi I noticed that if I attempt to read an Oracle table, via
ODBC, that has a column defined as a non-standard data type I get an exception. Using Oracle 9i I connected as SYSTEM and using ad-hoc sql I
executed ‘select * from AQ$_QUEUES’ and got
SystemError(#'exception occured',#(3221225477 35570678)). It works ok for ‘select * from
AQ$_QUEUE_TABLES’. I have the latest Oracle ODBC drivers installed. When I execute the same expression against a 10g database I
also get an exception SystemError(#'exception
occured',#(3221225477 1640673393)). Terry _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Re: [vwnc] ODBC access violation when reading Oracle table
|
|
Terry, If you have time, if you could send a
snippet of SQL that can ultimately generate such a table, I’d appreciate
it. I can then file an AR with your information for further evaluation. >From my
perspective, Cincom is definitely eager to stay ahead of any burgeoning database
trends—with the usual caveat about resources. - Dave From: Terry Raymond
[mailto:[hidden email]] Dave The table is one of the default tables
created when you create a new database the simple way. Any suggestions? I suspect that more and more
databases will be using the datatypes and not being able
to read the tables will put VW applications at a disadvantage. Terry From: Wallen, David
[mailto:[hidden email]] Sorry about this late response. I
don’t think the exdi is set up to work with user defined types. In 1998
we had an interface for Oracle’s then new object technology, which
includes user defined types. But Oracle seems to have quietly backed away from
that product line, and I don’t think we actually shipped and supported
it. From what I recall, the api was fairly cumbersome. Anyway, that’s just my hunch about
what’s going on. My 10g server doesn’t have the tables you
mentioned. - Dave From:
[hidden email] [mailto:[hidden email]] On Behalf Of Terry Raymond A little additional info; I tried the same thing only connecting via
the OracleEXDI and instead of an exception I got an Oracle error. ORA-24359: OCIDefineObject not invoked for
a Object type or Reference This is using vw 7.6. Terry From: Terry Raymond
[mailto:[hidden email]] Hi I noticed that if I attempt to read an Oracle table, via
ODBC, that has a column defined as a non-standard data type I get an exception. Using Oracle 9i I connected as SYSTEM and using ad-hoc sql I
executed ‘select * from AQ$_QUEUES’ and got
SystemError(#'exception occured',#(3221225477 35570678)). It works ok for ‘select * from
AQ$_QUEUE_TABLES’. I have the latest Oracle ODBC drivers installed. When I execute the same expression against a 10g database I also get an exception SystemError(#'exception
occured',#(3221225477 1640673393)). Terry _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
| Free forum by Nabble | Edit this page |