Monday, November 3, 2008

Writing File with pl/sql in Oralce

DECLARE
vInHandle utl_file.file_type;
vNewLine VARCHAR2(250);
BEGIN
vNewLine:='sadat';
vInHandle := utl_file.fopen('SADAT', 'test.sql', 'W');
utl_file.put_line(vInHandle, vNewLine);
utl_file.fclose(vInHandle);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('Exception');
END;
/

No comments:

search engine

Custom Search