create table TEST_XMLTYPE
(
VAR XMLTYPE
);

create or replace directory MYFILE
as 'g:\file';

create or replace procedure prc_test_xmltype(p_path varchar2,p_file varchar2)
is
v_file bfile;
v_xml xmltype;
v_clob clob;
begin
v_clob:=empty_clob();
v_file:=bfilename(p_path,p_file);
dbms_lob.fileopen(v_file,dbms_lob.file_readonly);
dbms_lob.loadfromfile(v_clob,v_file,dbms_lob.getlength(v_file));
dbms_lob.fileclose(v_file);
v_xml:=xmltype.createXML(v_clob);
insert into test_xmltype(var) values(v_xml);
commit;
end prc_test_xmltype;

SQL> exec prc_test_xmltype;
begin prc_test_xmltype; end;

PL/SQL: Statement ignored

Error Id: ORA-06550

Title: line string, column string: string

Description:

line string, column string: string

Action:

none

Cause:

Usually a PL/SQL compilation error.

Error Id: PLS-00306

Title: wrong number or types of arguments in call to ’string’

Description:

wrong number or types of arguments in call to ’string’

Action:

Check the spelling and declaration of the subprogram name. Also confirm that its call is correct, its parameters are of the right datatype, and, if it is not a built-in function, that its declaration is placed correctly in the block structure.

Cause:

This error occurs when the named subprogram call cannot be matched to any declaration for that subprogram name. The subprogram name might be misspelled, a parameter might have the wrong datatype, the declaration might be faulty, or the declaration might be placed incorrectly in the block structure. For example, this error occurs if the built-in square root function SQRT is called with a misspelled name or with a parameter of the wrong datatype.

-- 来自：