Re: SQL and PL/SQL Limitations

Thomas Kyte <tkyte_at_oracle.com> wrote in message news:<ajtgnl01s7t_at_drn.newsguy.com>...
> In article <5c3ada67.0208200452.535e6545_at_posting.google.com>,
> dxcreepin_at_va.prestige.net says...

[snip]

> >> >
> >> >
> >> >When I try to run my SQL statement now with the functions and types
> >> >above, I get:
> >> >ORA-00932: inconsistent datatypes
> >> >
> >> >Am I doing something wrong?
> >>
> >>
> >>Example please -- cut and paste from sqlplus. include server versions and such
> >> as well.
> >>
> >> I tested only on 817 and 9i r1/r2.
> >
> >I figured out the problem. I was using the wrong function... silly me.
> >I works as well as can be expected now, aside from the 4000 character
> >SQL limit. Is there a way around that using Reports 6i? Ultimately
> >this query will be used in Reports 6i.
>
>
> Confusion here -- the example above has a 4gig sql limit, not 4000?

Sorry for the confusion Tom. For me, reading is fundimental. I completely missed the inline view in the query statement. It works like a charm now. Thank you for all of your help. Received on Wed Aug 21 2002 - 08:15:41 CDT