Re: LONG column in Reports

Thanks Jonathan....I'll have a look.

Steve

Jonathan Lewis wrote:

> I think I posted a solution to this problem on
> Metalink a couple of weeks ago. You can
> write a stored function which takes the primary
> key as an input, selects the long for that key,
> and returns the first part of it as a varchar.
>
> Not a great solution, but it gets the job done.
>
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
>
>
> Steve Bell wrote in message <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.
>>