| |

VerySource

 Forgot password?
 Register
Search
View: 625|Reply: 2

On the access path of UTL_FILE package in Oracle? (Wait online)

[Copy link]

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-2-7 18:30:01
| Show all posts |Read mode
The UTL_FILE package is used in the stored procedure to operate the server file, but now it always prompts an invalid path. I have set up the following steps:
1.CREATE DIRECTORY utl AS 'E:\utl';
2.GRANT EXECUTE ON utl_file TO scott;

Then I re-logged in to the operator, why can't I use it?
Are there other places that need to be set?
Please expert guidance ~~
Reply

Use magic Report

0

Threads

8

Posts

7.00

Credits

Newbie

Rank: 1

Credits
7.00

 Invalid IP Address

Post time: 2020-3-30 20:00:02
| Show all posts
Does this actual path exist?
Reply

Use magic Report

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-4-2 21:45:01
| Show all posts
Solved, case problem
Depressed ~
Reply

Use magic Report

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

Points Rules

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

Quick Reply To Top Return to the list