Re: LONG column in Reports

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.

>