A Java procedure Question!!!

[see_one]

Hi all,

My friends at work have written a Java stored procedure and loaded the class file to user_objects. The procedure is supposed to write to a file. When they run the procedure from SQL Plus it gives them an error something like this, able to write to a physcial driver only. What we don't understand is, why it would not write to a mapped drive when the oracle database is on the same drive. We are using oracle 8i. If you guys can suggest something, that would really help me. Thanks.

[Srinivas_Sharma]

Hi,

Whats ur UTL_FILE path. does it point to the mapped drive.

give this sql stmt in ur sqlplus and see where ur utl_file_dir points to.

Select value from v$parameter where name like 'utl_file_dir'

Srini

[see_one]

I don't get any value when I run the select statement that wrote.


select * from v$parameter where name like 'utl_file_dir';

       NUM NAME                       TYPE VALUE                     ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ DESCRIPTION
---------- -------------------- ---------- ------------------------- --------- ----- --------- ---------- ----- --------------------------------------------------
       440 utl_file_dir                  2                           TRUE      FALSE FALSE     FALSE      FALSE utl_file accessible directories list

[Srinivas_Sharma]

hey

ask ur dba if its been setup or not?

Srini

[see_one]

I am kinda dba and everything here . Please let me know how I should do it. Thanks.

[Srinivas_Sharma]

The UTL_FILE_DIR parameter specifies one or more directories in which you can read/write files with the UTL_FILE package. You can list multiple directories in one statement, separated by a semi-colon, as in:

UTL_FILE_DIR=/tmp;/tmp/accounts;/apps/oracle/ar

so u specify ur mapped drive directory path in the above stmt.

S

[gandolf989]

I suggest that you use the create directory command. You can do this without restarting your database and you have better control over who can access that directory.

[see_one]

Is there a certain spot where I have to define that parameter in the init.ora file? I checked the init.ora file and it does not have any utl_file_dir parameter. Thanks for all your help.

[see_one]

Would the be right if create a directory with the syntax below.

SYNTAX:
CREATE [OR REPLACE] DIRECTORY directory AS 'path_name';

My Example:

CREATE DIRECTORY test_directory AS 'F:\test;

Thanks.

[gandolf989]

Originally posted by see_one
Is there a certain spot where I have to define that parameter in the init.ora file? I checked the init.ora file and it does not have any utl_file_dir parameter. Thanks for all your help.

If the parameter is not in you init file then you need to add it. You can put it anywhere. Or instead of that you can create directories. Either way will work. But if you add it to the init file, then you need to restart you database for it to work.