SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_file.fopen() help

630047Jan 6 2010 — edited Jan 6 2010

Oracle 10G R2
am trying to open a file through utl_file.fopen(dir, file, 'WB')
in my pl sql program.
but it is throughing error as bellow even directory path with 'D:'
Error report:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 29
ORA-06512: at "SYS.UTL_FILE", line 448
ORA-06512: at "EDRPUSER.TO_FILE", line 12
ORA-06512: at line 6
29280. 00000 - "invalid directory path"
*Cause: A corresponding directory object does not exist.
*Action: Correct the directory object parameter, or create a corresponding
directory object with the CREATE DIRECTORY comman

is it possible to open file in claint machine?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 3 2010

Added on Jan 6 2010

7 comments

1,804 views