avatar
e*r
1
从网上copy了UTL_FILE_TEST_WRITE(); 然后调用
utl_file_test_write ('D:\','log', v_link_id); 但是总有问题. 请指点
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 29
ORA-06512: at "SYS.UTL_FILE", line 448
ORA-06512: at "DN.UTL_FILE_TEST_WRITE", line 10
ORA-06512: at line 25
avatar
B*g
2
you can not use D:\ directly.
create a directory first

【在 e******r 的大作中提到】
: 从网上copy了UTL_FILE_TEST_WRITE(); 然后调用
: utl_file_test_write ('D:\','log', v_link_id); 但是总有问题. 请指点
: ORA-29280: invalid directory path
: ORA-06512: at "SYS.UTL_FILE", line 29
: ORA-06512: at "SYS.UTL_FILE", line 448
: ORA-06512: at "DN.UTL_FILE_TEST_WRITE", line 10
: ORA-06512: at line 25

avatar
e*r
3
I don't know why, even after creating a directory D:\dn, it still didn't
work. Here is a calling script, which is for finding duplicate records in
table called 'study'. 'study' table has two columns, one is 'link_id',
another is 'sequence'.
avatar
B*g
4
http://www.adp-gmbh.ch/ora/sql/create_directory.html

't
in

【在 e******r 的大作中提到】
: I don't know why, even after creating a directory D:\dn, it still didn't
: work. Here is a calling script, which is for finding duplicate records in
: table called 'study'. 'study' table has two columns, one is 'link_id',
: another is 'sequence'.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。