Utl_file_dir is a deprecated feature that was used before 9i came out Since 9i you should not use utl_file_dir and should only use real directories (which are not referred to as "dba directories", they are just "directories") utl_file_dir allowed you in the past to list a list of directories that UTL_FILEJul 10, 09 · To test if the utl_file_dir path in the initora file can indeed be written to Login as sysdba – 1 Create a test procedure CREATE OR REPLACE procedure utl_file_test_write (path in varchar2, filename in varchar2, firstline in varchar2, secondline in varchar2) is output_file utl_filefile_type;Jun 08, · Starting in Oracle Database 18c, the UTL_FILE_DIR parameter is no longer supported Instead, specify the name of a directory object The UTL_FILE_DIR initialization parameter is no longer listed in V$SYSTEM_PARAMETER and related views If you attempt to set this parameter, then the attempt fails Pl Sql の処理でデータベースサーバー内のテキストファイルを読み込む 書き出す Oracle Project Group O...
コメント
コメントを投稿