clob variable [message #38089] |
Tue, 19 March 2002 00:28 |
Epe
Messages: 99 Registered: March 2002
|
Member |
|
|
I'm trying to store an XML-file into a clob-variable using the next stored procedure :
_______________________________________________________
create or replace procedure lees_xml as
insCtx DBMS_XMLSave.ctxType;
rows number;
v_cloblocator clob;
p_filename varchar2(25) := 'ADM_MANAGERFOR.XML';
v_filelocator bfile := BFILENAME('EPEDIRC',
p_filename);
tablename varchar2(20) := 'ECS.ADM_MANAGERFOR';
begin
DBMS_LOB.fileopen(v_filelocator,
DBMS_LOB.file_readonly);
DBMS_LOB.loadfromfile(v_cloblocator,
v_filelocator,
DBMS_LOB.GETLENGTH(v_filelocator));
DBMS_LOB.fileclose(v_filelocator);
insCtx := DBMS_XMLSave.newContext(tablename);
rows := DBMS_XMLSave.insertXML(insCtx,
v_cloblocator);
DBMS_XMLSave.closeContext(insCtx);
commit;
end;
______________________________________________________
I get an "ora-22275 : numeric or value error : invalid LOB locator".
Anyone who can tell me what to do, and how ?
Thanks,
Epe
|
|
|