Re: Sql Problem

You can't use SELECT <long data type> in UNION, but you can use it in UNION ALL. Igor

reyre2_at_my-dejanews.com wrote:

> What is wrong with this query?
>
> SQL>
> 1 select t.text as action
> 2 from serv133.calls c, serv133.qw_text t
> 3 where c.pkey = 13729
> 4 and c.problemtext = t.qwkey
> 5 and t.fieldname = 'problemtext'
> 6 union
> 7 select t.text as action
> 8 from serv133.calls c, serv133.qw_text t
> 9 where c.pkey = 13729
> 10 and c.actiontext = t.qwkey
> 11* and t.fieldname = 'actiontext'
> SQL> /
> select t.text as action
> *
> ERROR at line 1:
> ORA-00997: illegal use of LONG datatype
>
> SQL>
>
> SQL> describe serv133.qw_text
> Name Null? Type
> ------------------------------- -------- ----
> QWKEY NOT NULL NUMBER(38)
> TABLENAME VARCHAR2(30)
> FIELDNAME VARCHAR2(30)
> TEXTKEY NUMBER(38)
> TEXT LONG
>
> tia
> Richard
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Jul 17 1998 - 11:47:04 CDT