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

Home -> Community -> Mailing Lists -> Oracle-L -> Problem with LONG_RAW column..

Problem with LONG_RAW column..

From: Makarand Natu <Makarand.Natu_at_originindia.com>
Date: Fri, 11 Aug 2000 17:27:38 +0530
Message-Id: <10586.114344@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0038B.5B4E5E70
Content-Type: text/plain

Hi Gurus,

I'm facing a problem with LONG RAW datatype. When I'm trying to read a LONG RAW table column ( with size < 32K ) in a PL/SQL LONG RAW variable it works well. However when the size of LONG RAW table column exceeds 32K it raises VALUE_ERROR exception. Foll. is my PL/SQL block...

DECLARE
  v_stuff LONG RAW;
BEGIN
  SELECT A.content /* A.content is a column of type LONG RAW */   INTO v_stuff
  FROM ows_content A
  WHERE a.oid=24 ;
  ...Reports VALUE_ERROR for size of A.content > 32K

As a workaround for the above problem when I try the foll SELECT UTL_RAW.SUBSTR(A.content,1,32000) INTO v_stuff this also reports ILLEGAL OPERATION.
I'm totally stuck on this.
Help requested.

TIA,
Makarand Natu

------_=_NextPart_001_01C0038B.5B4E5E70
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>Problem with LONG_RAW column..</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2 FACE="Arial">Hi Gurus,</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">I'm facing a problem with LONG RAW datatype.</FONT>
<BR><FONT SIZE=2 FACE="Arial">When I'm trying to read a LONG RAW table column ( with size &lt; 32K ) in a </FONT>
<BR><FONT SIZE=2 FACE="Arial">PL/SQL LONG RAW variable&nbsp; it works well.</FONT>
<BR><FONT SIZE=2 FACE="Arial">However when the size of LONG RAW table column exceeds 32K it raises</FONT>
<BR><FONT SIZE=2 FACE="Arial">VALUE_ERROR exception. Foll. is my PL/SQL block...</FONT>
</P>

<P><FONT SIZE=2 FACE="Courier New">DECLARE</FONT>
<BR><FONT SIZE=2 FACE="Courier New">&nbsp; v_stuff LONG RAW; </FONT>
<BR><FONT SIZE=2 FACE="Courier New">BEGIN</FONT>
<BR><FONT SIZE=2 FACE="Courier New">&nbsp; SELECT A.content&nbsp; /* A.content is a column of type LONG RAW */</FONT>
<BR><FONT SIZE=2 FACE="Courier New">&nbsp; INTO&nbsp;&nbsp; v_stuff</FONT>
<BR><FONT SIZE=2 FACE="Courier New">&nbsp; FROM&nbsp;&nbsp; ows_content A</FONT>
<BR><FONT SIZE=2 FACE="Courier New">&nbsp; WHERE a.oid=24 ;</FONT>
<BR><FONT SIZE=2 FACE="Courier New">&nbsp; ...Reports VALUE_ERROR for size of A.content &gt; 32K</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">As a workaround for the above problem when I try the foll</FONT>
<BR><FONT SIZE=2 FACE="Arial">SELECT UTL_RAW.SUBSTR(A.content,1,32000) INTO v_stuff</FONT>
<BR><FONT SIZE=2 FACE="Arial">this also reports ILLEGAL OPERATION.</FONT>
<BR><FONT SIZE=2 FACE="Arial">I'm totally stuck on this. </FONT>
<BR><FONT SIZE=2 FACE="Arial">Help requested.</FONT>
</P>

<P><B><FONT COLOR="#800000" SIZE=2 FACE="Comic Sans MS">TIA,</FONT></B>
<BR><B><FONT COLOR="#800000" SIZE=2 FACE="Comic Sans MS">Makarand Natu</FONT></B>
Received on Fri Aug 11 2000 - 06:57:38 CDT

Original text of this message

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