On Jan 5, 11:43 pm, zalesam <bindu.rang...@gmail.com> wrote:
> Hi,
> In my procedure I am trying to read a table and write the content to a
> text file and store it in a directory. But I am getting this error.
>
> ORA-29283: invalid file operation
> ORA-06512: at "SYS.UTL_FILE", line 475
> ORA-29283: invalid file operation
> ORA-06512: at line 14
>
> create or replace PACKAGE BODY pkg_test AS
> DUMP_DIR CONSTANT VARCHAR2(30) := 'TEST_TEMP';
> PROCEDURE dump_test(Filename IN VARCHAR2) IS
> c sys_refcursor;
> fout utl_file.file_type;
>
> BEGIN
>
> ------
> -----
> ----
> fout := utl_file.fopen(DUMP_DIR, Filename, 'w', 32767);
> ---
> ----
> END dump_test;
> END pkg_test;
>
> I have created this directory using the following command.
>
> CREATE OR REPLACE DIRECTORY test_temp AS '/home/Sam/test_temp'
>
> output
> ---------
> CREATE OR REPLACE DIRECTORY succeeded.
>
> on my file system I created test_temp (/home/Sam/)and gave read,write
> and execute Privileges.
>
> In sql Developer I can see the directory created. But I am not sure
> what is going wrong.
> Please help.
>
> Thanks,
> Sam
You do have a package specification for this body? You don't show any
code to create one.
Modifying your code slightly (to provide a package spec and use
Windows rather than Linux/UNIX) produces this:
SQL> CREATE OR REPLACE DIRECTORY test_temp AS 'c:\test_temp';
Directory created.
SQL>
SQL> create or replace PACKAGE pkg_test AS
2
3 PROCEDURE dump_test(Filename IN VARCHAR2);
4
5 END pkg_test;
6 /
Package created.
SQL>
SQL> create or replace PACKAGE BODY pkg_test AS
2
3 DUMP_DIR CONSTANT VARCHAR2(30) := 'TEST_TEMP';
4
5 PROCEDURE dump_test(Filename IN VARCHAR2) IS
6 c sys_refcursor;
7 fout utl_file.file_type;
8
9 BEGIN
10
11
12 ------
13 -----
14 ----
15 fout := utl_file.fopen(DUMP_DIR, Filename, 'w',
32767);
16 ---
17 ----
18 END dump_test;
19
20 END pkg_test;
21 /
Package body created.
SQL>
SQL> exec pkg_test.dump_test('yarg')
PL/SQL procedure successfully completed.
SQL> $ls -l c:\test_temp
total 0
-rw-rw-rw- 1 user group 0 Jan 6 11:27 yarg
SQL>
I can't get it to fail. You need to provide more information before
anyone can see what you're doing incorrectly.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
