Home » SQL & PL/SQL » SQL & PL/SQL » Help w/CLOB error
Help w/CLOB error [message #268458] Tue, 18 September 2007 14:24 Go to next message
marks20101
Messages: 74
Registered: May 2005
Member
I'm trying to write this out in chunks, but I keep getting the following error;
ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
Not sure what is going on with this error. Never used RAW before and it seems like this is where the error is (in bold).

dbms_lob.read(vxml,bytelen,vstart,my_vr);
vxml file is 85m

vxml cLOB;
vstart NUMBER := 1;
bytelen NUMBER := 32000;
lenxml number;
my_vr RAW(32000);
l_output utl_file.file_type;

BEGIN
-- define output directory
l_output := utl_file.fopen('IO', p_month||'_'||p_day||'.wme','w', 32760);
vstart := 1;
bytelen := 32000;

-- get length of clob

SELECT dbms_lob.getlength(manual_cl)
INTO lenxml
FROM catalog
WHERE item_id = 3;

-- select clob into variables

SELECT manual_cl
INTO vxml
FROM catalog
WHERE item_id = 3;

vstart := 1;
WHILE vstart < lenxml and bytelen > 0
LOOP

   dbms_lob.read(vxml,bytelen,vstart,my_vr);
   utl_file.put(l_output,my_vr);

   -- set the start position for the next cut
   vstart := vstart + bytelen;

   lenxml := lenxml - bytelen;
   IF lenxml < 32000 THEN --32000
      bytelen := lenxml;
   END IF;
end loop;

utl_file.fclose(l_output);

end;
/

Re: Help w/CLOB error [message #268459 is a reply to message #268458] Tue, 18 September 2007 14:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I don't have the time to guess which line of code is generating this error.

Too bad for all concerned the you decided to not read or not follow the posting guidelines as stated in the #1 STICKY post at top of this forum.

You're On Your Own (YOYO)!
Re: Help w/CLOB error [message #268476 is a reply to message #268458] Tue, 18 September 2007 16:47 Go to previous messageGo to next message
marks20101
Messages: 74
Registered: May 2005
Member
Are you for real or just an *******? I guess you’re just an ******* so; I'll call you ******* or **** ****. The error is in bold yo yo! You must not have work, is this why you’re an *******? Or you just can't figure it out because you’re an ******* got that yo yo?

Error is in bold
dbms_lob.read(vxml,bytelen,vstart,my_vr);

BTW, I don't need your help anacedent the ******* idiot! I need someone that is more on the professional level not childish comments. Are you even an American with a name like that?

This use to be a good forum. Why do you let unprofessional yo yo's moderate?



Profanity replaced with asterisks by moderator.

[Updated on: Sat, 22 September 2007 23:52] by Moderator

Report message to a moderator

Re: Help w/CLOB error [message #268477 is a reply to message #268476] Tue, 18 September 2007 16:51 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
I think this answer just reduced the chance of getting help to just about zero.
especially since I close this thread.
However unhelpful anyone's comment may be, we do try to keep certain standards.
I must say that Ana could keep it down a bit as well...
Previous Topic: Performace of CLOBs in table.
Next Topic: object type
Goto Forum:
  


Current Time: Mon Feb 17 18:59:59 CST 2025