| |

VerySource

 Forgot password?
 Register
Search
View: 4|Reply: 3

Oracle10g using utl_file.fopen encountered problems, ask for advice, very urgent!

[Copy link]

1

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-1-27 08:40:01
| Show all posts |Read mode
Database oracle10g, used in stored procedures
utl_file.fopen ('csv_dir', 'csvfilename.csv', 'W');
One sentence, where 'csv_dir' is produced with
create or replace directory csv_dir as 'c:\temp\csv'
Where 'c:\temp\csv' is the actual directory.
But the execution of the stored procedure error, the following error is reported
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
ORA-06512: at "ADMIN.CSVTEST", line 14
ORA-06512: at line 1

What are the reasons for this? !!
The entire stored procedure is as follows:

CREATE OR REPLACE PROCEDURE "ADMIN". "CSVTEST" AS
    NFNO UTL_FILE.FILE_TYPE;-csv file type
    BEGIN

      -CSV file open
      NFNO: = UTL_FILE.FOPEN ('csv_dir', 'xumztest.csv', 'A');

          UTL_FILE.PUT_LINE (NFNO, 'a, b, c, d');

    -CSV file close

      UTL_FILE.FCLOSE (NFNO);

  END CSVTEST;
Reply

Use magic Report

0

Threads

66

Posts

45

Credits

Newbie

Rank: 1

Credits
45

 China

Post time: 2020-2-21 02:15:01
| Show all posts
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33

Is it due to insufficient directory access?
Reply

Use magic Report

0

Threads

13

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 China

Post time: 2020-3-9 13:00:02
| Show all posts
Put UTL_FILE.FOPEN ('csv_dir', 'xumztest.csv', 'A');
Change the lowercase characters to uppercase.
Reply

Use magic Report

0

Threads

6

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 Invalid IP Address

Post time: 2020-5-25 09:30:01
| Show all posts
http://blog.csdn.net/sanque/archive/2006/01/19/583619.aspx

This can be answered above
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list