Help w/CLOB error [message #268458] |
Tue, 18 September 2007 14:24  |
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 #268476 is a reply to message #268458] |
Tue, 18 September 2007 16:47   |
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  |
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...
|
|
|