DECLARE
file1 utl_file.file_type;
CURSOR C_TABLE IS
SELECT SETTING
FROM KZHOU.APPLICATIONSETTING;
begin
file1:=utl_file.fopen('CN_OPD1','APPLICATIONSETTING.CSV','W');
FOR v_Record IN C_TABLE LOOP
utl_file.put_line(file1,v_Record.SETTING);
END LOOP;
utl_file.fclose(file1);
END;
/
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 10
SQL> desc KZHOU.APPLICATIONSETTING;
Name Null? Type
----------------------------------------- -------- ----------------------------
SETTING CLOB
请教:CLOB的字段,应该怎么转换才能正常写入文件呀?
SQL>SELECT SETTING FROM KZHOU.APPLICATIONSETTING;
SETTING
--------------------------------------------------------------------------------
Please select...