请教个xml读写的问题
create or replace directory xmlfiles as 'D:\PQTDB';-----创建了目录,
grant read, write on directory xmlfiles to public;-----赋予了权限,
select directory_name, directory_path from all_directories;-----目录信息也能查询到,
select dbms_lob.GETLENGTH(bfilename('XMLDIR','claim77804.xml')) as length from dual;-----文件也能读取,
create table invoiceXML_col
(
inv_id number primary key,
inv_doc XMLType
);-----表也能创建成功,
insert into invoiceXML_col values(1,XMLType(bfilename('XMLDIR','claim77804.xml'),nls_charset_id('AL32UTF8')));
但是在插入数据的时候老是报错" ora-06553:pls-306:调用'xmltype'时参数个数或者类型错误"。 不知道怎么处理啊,希望懂行的人指点下吧。。先谢谢了~~
|