Re: LONG

if someone can get us the structure of the LONG variables, that would solve all the matter. What I have seen is, the contents of LONG variables are displayed as left aligned; so I guess, Oracle converts everything into character before storing them into database. If that is so, then we should not have any problem in using the character functions with LONG data type.

Thomas, the example I gave works well........... ----- Original Message -----
From: Thomas L. Harleman <tharleman_at_IQuest.net> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Saturday, May 13, 2000 11:04 PM
Subject: 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-----
Venkataramany
Sent: Friday, May 12, 2000 10:59 AM
To: Multiple recipients of list ORACLE-L

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

also send the HELP command for other information (like subscribing).

--
Author: Thomas L. Harleman
  INET: tharleman_at_iquest.net

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