Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00932: inconsistent datatypes: expected - got -; oracle 9i bug???

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

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 19 Apr 2006 03:24:20 -0700
Message-ID: <1145442260.733127.320670@i39g2000cwa.googlegroups.com> 





Dale wrote:


> Should have said " I know there is a bug where leaving out the "CAST"

> in my sample code

> generates the same exception on 9i and 10g release 1", not " 10g

> release 2"




"SELECT *" can be a problem when querying TABLE() expressions in 9i
(ORA-22905 cannot access rows from a non-nested table item). The
workaround is to specify a column list (which is good practice in any
case).
Received on Wed Apr 19 2006 - 05:24:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US