| Excel/Oracle ODBC with Nested Tables [message #521513] |
Tue, 30 August 2011 14:10  |
emoore
Messages: 3
Registered: February 2008
|
Junior Member |
|
|
I'm attempting to pull data from an Oracle 10g database (Enterprise Ed.) into an Excel Spreadsheet, using the ODBC driver supplied by an Oracle 10g Client installation.
I am able to pull most data that I want this way, however when I try to pull anything from our database that is contained in a nested table (I hate those things), I'm receiving a "General ODBC Error" pop-up from Excel.
I can execute the same query in SQL Plus without error.
Is there a log or trace file in Windows somewhere that might give some clue as to what is causing the error?
Thank you all in advance!
|
|
|
|
|
|
| Re: Excel/Oracle ODBC with Nested Tables [message #521714 is a reply to message #521545] |
Thu, 01 September 2011 09:01  |
emoore
Messages: 3
Registered: February 2008
|
Junior Member |
|
|
After some more research, I've found that the ODBC does not support Oracle-specific objects such as nested tables. Oracle calls what I'm seeing "expected behavior", and recommended un-nesting the tables to retrieve the data into a view.
Thank you for your help!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
