RE: GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE

From: Ramasamy, Baskar <Baskar.Ramasamy_at_calanais.com>
Date: Thu, 05 Jul 2001 02:53:34 -0700
Message-ID: <F001.003415DD.20010705025549@fatcity.com>

Mark,

You could write a plsql by defiining a variable with 32K (like fetch_log_value varchar2(32760))
You could fetch the long data type column value into fetch_long_value variable after opening the cursor. After that you can use substr on this variable.

Baskar

-----Original Message-----
Sent: 04 July 2001 21:56
To: Multiple recipients of list ORACLE-L

HI GURUS, If I have a table that has a field with long data type and I want to get the first 250 characters out of it how can I do it. I tried using SUBSTR(long data type field, 1, 250) but it complained about "ORA-00932: inconsistent datatypes". I then tried TO_CHAR(SUBSTR(long data type field, 1, 250)) but still gave me the same result. Tried TO_VARCHAR2 but to no avail.

Thanks,
Mark

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Liggayu
INET: markliggayu_at_allweatherwindows.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ramasamy, Baskar
INET: Baskar.Ramasamy_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------