Re: LONG column in Reports

From: Jim Gregory <JG200024_at_NCR.com>
Date: Thu, 15 Feb 2001 10:59:17 -0500
Message-ID: <3a8bfcd8$1@rpc1284.daytonoh.ncr.com>

You cannot use a function with a LONG data type. In SQL*Plus, you would issue a "set long 100" command prior to the select so that 100 chars of the LONG field would be returned. I'm not familiar with Crystal Reports so don't know if something like that exists or not within the Crystal code.

HTH

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
Steve Bell <swayne.bell_at_sympatico.ca> wrote in message
news:3A8A8F57.2D6A6F80_at_sympatico.ca...


> Hi all,

>

> I just listened to a voice message left to me by a coworker...he's

> working with Crystal Reports and is trying to show the first 100

> characters of an Oracle LONG column in his report....the helpdesk at

> Seagate (Crystal) told him to create a view containing the first 100

> characters using SUBSTR....however, this returns an error

> ORA-00932: Inconsistent datatypes

>

> I'm wondering if it's possible to break up a LONG field in this way or

> if another methodology is required.

>

> Thanks for any help in advance....

> PS: I would've searched the archives on this one but they seem to be

> missing in action :)

>

> Steve

>

Received on Thu Feb 15 2001 - 09:59:17 CST