Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to get the length of LONG RAW column

How to get the length of LONG RAW column

From: <wagen123_at_yahoo.com>
Date: 12 Jan 2005 15:47:36 -0800
Message-ID: <1105573656.134773.27920@c13g2000cwb.googlegroups.com>


Hi,

Oracle9i 9.2.0.6

How can I get the length of a LONG RAW column from sqlplus/plsql? It looks like the following works for RAW datatype ONLY.

Create utl_raw package
@$ORACLE_HOME/rdbms/admin/utlraw.sql.
$ORACLE_HOME/rdbms/admin/prvtrawb.plb

SET SERVEROUTPUT ON SIZE 1000000 DECLARE
a NUMBER;
b LONG RAW;
CURSOR c1 is SELECT c1 FROM junk;
BEGIN
OPEN c1;
LOOP
FETCH c1 INTO b ;
EXIT WHEN c1%NOTFOUND;
a := utl_raw.length(b);
DBMS_OUTPUT.PUT_LINE('LENGTH OF COLUMN IS = ' || a); END LOOP;
END;
/

Thanks
wagen Received on Wed Jan 12 2005 - 17:47:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US