How can i extract (substr(field,1,200) ) a substring on a long or long raw field

From: Ronald Berube <Berube.ronald_at_tourisme.gouv.qc.ca>
Date: 1998/04/20
Message-ID: <353b9684.0_at_news.total.net>#1/1

Can someone, can indicate me how to extract a substring from a long or long raw field.
Every time i try to extract extract substr(field,1,200) the oracle server return me
type of data not compatible

Thank's for any help
Ronald
berube.ronald_at_tourisme.gouv.qc.ca Received on Mon Apr 20 1998 - 00:00:00 CEST

This message: [ Message body ]
Next message: Tomas Gardson: "Re: Power Objects"
Previous message: duri_at_xs4all.nl: "ORA-06508: PL/SQL: could not find program unit being called"
Next in thread: James Preston: "Re: How can i extract (substr(field,1,200) ) a substring on a long or long raw field"
Reply: James Preston: "Re: How can i extract (substr(field,1,200) ) a substring on a long or long raw field"
Maybe reply: Arie Zevenbergen: "Re: How can i extract (substr(field,1,200) ) a substring on a long or long raw field"
Maybe reply: James: "Re: How can i extract (substr(field,1,200) ) a substring on a long or long raw field"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message