DECLARE
file1 utl_file.file_type;
CURSOR C_TABLE IS
SELECTSETTING
FROM KZHOU.APPLICATIONSETTING;
begin
file1:=utl_file.fopen('CN_OPD1','APPLICATIONSETTING.CSV','W');
FOR v_Record INC_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
