RE: Long Raw size 7.3.4

From: Kevin Lange <kgel_at_ppoone.com>
Date: Tue, 17 Jul 2001 13:44:22 -0700
Message-ID: <F001.0034CB6A.20010717133530@fatcity.com>

Thanks for the corrections and the info Richard. I did not know that. Guess I'll just shut up now .....

-----Original Message-----
Sent: Tuesday, July 17, 2001 2:12 PM
To: ORACLE-L_at_fatcity.com; kgel_at_ppoone.com

LOB doesn't exisit until Oracle8. And even in Oracle8 you can't use DBMS_LOB
to find out about column size on a LONG RAW.

To find out about the size of LONG RAW, you can write a PL/SQL stored procedure,
or use UTL_RAW.length() both of which has limitations. Basically, these will fail
of the LONG RAW is bigger than 30k or so.

If you store something bigger than that in your LONG RAW column, you have to resort to write a program in C, or Java ,etc. to read it and calculate the size.

HTH Richard Ji

>>> kgel_at_ppoone.com 07/17/01 03:46PM >>> Don't be ashamed.......... 7.3.4 is a great version of oracle.

You should take a look at the provided set of built-in packages. In particular, the one called DBMS_LOB.

-----Original Message-----
Sent: Tuesday, July 17, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L

I am embarrassed to admit that we still have a database running 7.3.4 Anyone know how to determine the size of a long raw column in this old environment?

TIA,
--

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

Author: Michael Barger
INET: mbarger_at_verio.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 also send the HELP command for other information (like subscribing).
--

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

Author: Kevin Lange
INET: kgel_at_ppoone.com

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

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