小问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

小问题

小问题# Database - 数据库

e*r2008-12-07 08:12

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

B*g2008-12-07 08:12

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

e*r2008-12-07 08:12

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'.

B*g2008-12-07 08:12

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'.

e*r2008-12-07 08:12

5 楼

thanks, however I don't have priviledge to create a directory.

【在 B*****g 的大作中提到】

: http://www.adp-gmbh.ch/ora/sql/create_directory.html
:
: 't
: in