do I have to set any parameters in the init.ora file, if so what are
those and where can I find init.ora file ? I did exactly the same as
you mentioned and still getting the same error.
Thanks,
Sam
On Jan 6, 9:30 am, ddf <orat...@msn.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
