Oracle 7 - long input

From: <_at_rennes>
Date: Mon, 23 Feb 2004 17:16:18 +0100
Message-ID: <c1d8pp$r38$1@s1.read.news.oleane.net>

Hello, i have a problem (oracle 7) in an union like that :

---

select *
from
((
select distinct

       o.owner#, o.name, po.name,
       ' ' "SOURCE",
       count(*) "Nb dep"

from sys.obj$ o, sys.obj$ po, sys.dependency$ d where o.obj# = d.d_obj#
and po.obj# = d.p_obj#
and o.owner# in (userenv('SCHEMAID'), 1 /* PUBLIC */)

and o.type  in (2,  4, 7, 8, 9, 11)
and po.type in (2,  4, 7, 8, 9, 11)
group by o.owner#, o.name, po.name,
         o.type, po.type

)
union all
(
select distinct

       o.owner#, o.name, '', '', '', '', v.text "SOURCE", 0 from sys.obj$ o, sys.view$ v
where o.obj# = v.obj#(+)
))
where name like 'VUE_ETAT_%'

---

Oracle 7 say me : ORA-01790: expression must have same datatype as corresponding expression
How can i do that ?

Thanks Received on Mon Feb 23 2004 - 10:16:18 CST