Re: ORA-00932: inconsistent datatypes: expected - got -; oracle 9i bug???

Hi Daniel,

Thanks for the link! I actually use array processing for some of our stored procs but ...

First off, I believe the types are consistent. If I have the select statement is "select * from test_view" then all is well. The problems comes up when "test_view" is used twice - hence the union to demonstrate the problem.

As for your question: The original problem uses JDBC and complex query that uses an object hierarchy and nested tables. This example was just thrown together to demonstrate the problem and to rule out JDBC or the rest of the query as being the cause of the ORA-00932 exception. As I said, the code works fine in 10g release 2 but I need it to work on 9i. I know there is a bug where leaving out the "CAST" in my sample code generates the same exception on 9i and 10g release 2. The "CAST" is a work around for the problem - I was wondering if there was also a workaround for this problem in 9i.

Thanks,

Dale Received on Tue Apr 18 2006 - 18:24:52 CDT