CREATE OR REPLACE PROCEDURE test_xxx
is
src CLOB;
BEGIN
src := dbms_xmlgen.getXML('SELECT * FROM ze_file where rownum<=2');
怎么把src写到文件中呢,请大家帮个忙,把这个代码补齐了!谢谢
end;
is
src CLOB;
BEGIN
src := dbms_xmlgen.getXML('SELECT * FROM ze_file where rownum<=2');
怎么把src写到文件中呢,请大家帮个忙,把这个代码补齐了!谢谢
end;
GRANT READ,WRITE ON DIRECTORY TEST_DIR to yourUser;CREATE OR REPLACE PROCEDURE TEST_XXX IS
L_F UTL_FILE.FILE_TYPE;
BEGIN
L_F := UTL_FILE.FOPEN('TEST_DIR', 'xx.txt', 'w', 32767);
UTL_FILE.PUT_LINE(L_F,
DBMS_XMLGEN.GETXML('SELECT * FROM ze_file where rownum <=2'));
UTL_FILE.FCLOSE(L_F);
END;
/