Re: Sql Problem

Thanks for the reply!

However this is my new error.

  1 select t.text as problem
  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 all
  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> /
ERROR:
ORA-03113: end-of-file on communication channel

-r

In article <35AF8007.F171EA93_at_solect.com>,   Igor Popov <ipopov_at_solect.com> wrote:
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 20 1998 - 15:37:45 CDT