utPLSQL / Bugs Archive (Use GitHub now) / #30 testpkg always fails with "invalid directory path"

testpkg always fails with "invalid directory path"

#30 testpkg always fails with "invalid directory path"

Status: Closed-NotABug

Owner: nobody

Labels: None

Seen in version: [other - please specify]

Oracle version: [Unknown]

Priority: Medium

Fixed in version: [none]

Updated: 2015-02-09

Created: 2008-10-01

Creator: Victor Engmark

Private: No

How to reproduce (from Windows XP command shell):

C:
mkdir tests
sqlplus user/pass@db
exec utgen.testpkg(package_in => 'pkg_foo', output_type_in => utgen.c_file, dir_in => '/tests');

This always results in the following error:

BEGIN utgen.testpkg(package_in => 'pkg_foo', output_type_in => utgen.c_file, dir_in => '/tests'); END;

*
ERROR at line 1:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 424
ORA-06512: at "USER.UTGEN", line 302
ORA-06512: at "USER.UTGEN", line 782
ORA-06512: at "USER.UTGEN", line 912
ORA-06512: at line 1

I've also tried passing the directory as tests, \tests, c:\tests and c:/tests, with the same result. What gives?

Discussion

Victor Engmark - 2008-10-01

It looks like this is related to http://utplsql.sourceforge.net/Doc/admin.html#UTL_FILE. Could you please link to this in http://utplsql.sourceforge.net/Doc/utgen.html#testpkg ?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nobody/Anonymous - 2009-02-26

You need to configure Oracle so the UTL_FILE package can write to "C:\TESTS". Consult the Oracle documentation on how to do this.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Walker - 2013-10-12

Status: open --> Open

Priority: 5 --> Medium
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Walker - 2013-10-12

Fixed in version: --> [none]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

labels: utGen -->
Description has changed:

Diff:

--- old
+++ new
@@ -1,21 +1,22 @@
 How to reproduce \(from Windows XP command shell\):
-C:
-mkdir tests
-sqlplus user/pass@db
-exec utgen.testpkg\(package\_in =&gt; 'pkg\_foo', output\_type\_in =&gt; utgen.c\_file, dir\_in =&gt; '/tests'\);
+
+    C:
+    mkdir tests
+    sqlplus user/pass@db
+    exec utgen.testpkg(package_in => 'pkg_foo', output_type_in => utgen.c_file, dir_in => '/tests');

 This always results in the following error:
-BEGIN utgen.testpkg\(package\_in =&gt; 'pkg\_foo', output\_type\_in =&gt; utgen.c\_file, dir
-\_in =&gt; '/tests'\); END;

-\*
-ERROR at line 1:
-ORA-29280: invalid directory path
-ORA-06512: at "SYS.UTL\_FILE", line 18
-ORA-06512: at "SYS.UTL\_FILE", line 424
-ORA-06512: at "USER.UTGEN", line 302
-ORA-06512: at "USER.UTGEN", line 782
-ORA-06512: at "USER.UTGEN", line 912
-ORA-06512: at line 1
+    BEGIN utgen.testpkg(package_in => 'pkg_foo', output_type_in => utgen.c_file, dir_in => '/tests'); END;

-I've also tried passing the directory as 'tests', '\tests', 'c:\tests' and 'c:/tests', with the same result. What gives?
+    *
+    ERROR at line 1:
+    ORA-29280: invalid directory path
+    ORA-06512: at "SYS.UTL_FILE", line 18
+    ORA-06512: at "SYS.UTL_FILE", line 424
+    ORA-06512: at "USER.UTGEN", line 302
+    ORA-06512: at "USER.UTGEN", line 782
+    ORA-06512: at "USER.UTGEN", line 912
+    ORA-06512: at line 1
+
+I've also tried passing the directory as `tests`, `\tests`, `c:\tests` and `c:/tests`, with the same result. What gives?

Seen in version: --> [other - please specify]
Oracle version: --> [Unknown]

Paul Walker - 2013-10-24

Applied MarkDown formatting for readability

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Walker - 2013-10-24

If the post from "Anonymous" above correctly identifies the issue, is this sufficiently clear in the documentation?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Walker - 2015-02-09

status: Open --> Closed-NotABug
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

testpkg always fails with "invalid directory path"

Fixed in version

Searches

Help

#30 testpkg always fails with "invalid directory path"

Discussion