Re: LONG column in Reports

Hi ! The seagate support is plain wrong, Oracle (any version) don´t have support for manipulating LONG fields (the manuals clearly states : LONGs can´t be in WHERE clauses, in string functions like SUBSTR, etc). If you are using 8i,
you can convert the LONG fields in LOB fields , and use the built-in LOB-related functions/procedures to manipulate it.   If you are using 7.x , you can read the initial 32K of a long field using PL/SQL or PRO*C, otherwise your options will be veri limited.

[]s

     Chiappa

In article <3A8A8F57.2D6A6F80_at_sympatico.ca>, Steve Bell <swayne.bell_at_sympatico.ca> writes:
>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
>

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net