Dale wrote:
> 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
From your demo I can't tell but often what shows up in 10g will also
show up in the latter patches to 9i. You might want to check the list
of things "fixed" in patches later than yours if you do not have the
most recent 9i patches installed.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Apr 19 2006 - 10:46:24 CDT
