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: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
