HELP!!! PL/SQL write to a file# Database - 数据库
n*s
1 楼
I am very new to PL/SQL. Wish somebody can help me out.
Try to write something to a local file from a procedure, not just spool the
buffer, coz the buffer has limit of 255 char per line which is not large
enough for me. If you know how to increase this, please let me know.
I googled and found a package called UTL_FILE. Following the syntex, I wrote
something like this:
DECLARE
f utl_file.file_type;
BEGIN
f := utl_file.fopen('c:/nerdgirl', 'test.txt', 'w');
utl_file.put_line(f, 'blahblah
Try to write something to a local file from a procedure, not just spool the
buffer, coz the buffer has limit of 255 char per line which is not large
enough for me. If you know how to increase this, please let me know.
I googled and found a package called UTL_FILE. Following the syntex, I wrote
something like this:
DECLARE
f utl_file.file_type;
BEGIN
f := utl_file.fopen('c:/nerdgirl', 'test.txt', 'w');
utl_file.put_line(f, 'blahblah