RE: LONG

I've done this before. If I remember correctly, I created a varchar2 variable and copied the LONG value into it. Then I performed the string functions on that varchar2 variable. Actually, I think I created a generic function with a varchar2 parameter and passed the LONG to it. I don't believe you can execute character functions on LONG columns directly.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rajagopal Venkataramany
Sent: Friday, May 12, 2000 10:59 AM
To: Multiple recipients of list ORACLE-L Subject: Re: LONG

Atish,

  Sorry to say that I do not agree with your view.

  Could you please provide us with examples to proove that this   works...

Regards
Rajagopal Venkataramany

----Original Message Follows----
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thu, 11 May 2000 02:24:28 -0800

Yes, u can use any character function with long in pl/sql....... but in sqlplus this gives datatype mismatch.

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 11, 2000 11:57 AM

Hi guru´s
i want to know if is possible to do a substr or a instr in plsql with a LONG field?
thanks for all,

--
Author: Solis Llera, Eduardo
   INET: esolis_at_mapfre.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).


--
Author: Atish Prasad Das
   INET: atish.das_at_wipro.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).

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Author: Rajagopal Venkataramany
  INET: rajagopalvr_at_hotmail.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