Sql Problem

From: <reyre2_at_my-dejanews.com>
Date: Thu, 16 Jul 1998 19:39:43 GMT
Message-ID: <6olktv$e6a$1@nnrp1.dejanews.com>

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 Thu Jul 16 1998 - 14:39:43 CDT