Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Confused about UTL_file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Confused about UTL_file
# 1  
Old 04-16-2009
Confused about UTL_file
Does one need to add to UTL_file_dir the path?

I do not have the ability to create directories, againest policies.
# 2  
Old 04-16-2009
need way more info, tim.

+ operating system / shell

+ what is UTL_file_dir??

+ do you mean the PATH variable?

+ what shell are you in?

+ can you overwrite your ~/.profile, ~/.cshrc or ~/.kshrc etc??
# 3  
Old 04-16-2009
Thanks for answering.
We are on Sun OS
we are using ksh and sh shell scripts calling sqlplus Oracle 9i
Utl_file_dir path variable
is this required to be set becuase I keep getting invalid path .
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
I am a user and cannot overwrite any profile
# 4  
Old 04-16-2009
There is an Oracle instance parameter that enumerates what directories you can write to, utl_file_dir, this for the UTL_FILE package. Look in the init.ora file or use :
Code:
spool t.lis
select * from v$parameter ;
spool off

read the t.lis file for parameters.

Quirk - this is purely internal to Oracle.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Confused with if/then

Hi All, I'm pretty new to this so please bear with me... I'm trying to write a bash script to first search in a file for a string of characters; if the characters exist than skip the rest of the code until you get to the last line and run that command /sbdin/ldconfig; if the string doesn't... (2 Replies)
Discussion started by: gmdune
2 Replies

2. Ubuntu

New and Confused

Hello, I am having a problem with Dual Booting Windows XP Pro and Linux Mint. I have Three Hard Drives, One Hard Drive has Linux Mint Loaded on it. When it is hooked up to the computer by itself it works great. This is an IDE Drive. The Second Hard Drive has Window XP Pro loaded on it.... (3 Replies)
Discussion started by: Forextrading
3 Replies

3. Programming

Hi Folks UTL_FILE Issue.

Hi Folks UTL_FILE Issue. I want to do detail study about the UTL FILE package could any one please provide me some of the best detail utl package links to go through and implement in my project will be very help full thanks a ton!!! Rgds Ann. (1 Reply)
Discussion started by: Haque123
1 Replies

4. Solaris

Confused c#t#d#s#

I am confused c#t#d#s# once I learn the following : slice 0 ...... 0 to 2520 slice 1....... 2521 to 2840 slice 6........2841 to 8891 slice 2........0 to 8891 really really confused. Please explain. (8 Replies)
Discussion started by: deltakutty
8 Replies

5. UNIX for Dummies Questions & Answers

Confused with the permission

Hi, One of the directory in my folder has the following persion : drwxr-sr-x Can any one explain this permission and how can his occur ? This folder is created with Win SCP. Any folder created with win SCP is being set to this permission only. (1 Reply)
Discussion started by: risshanth
1 Replies

6. UNIX for Dummies Questions & Answers

confused

A red hat linux ftp server exists in which a file exists. My problem is I need to connect to this server from my windows xp terminal which is in the same network & retrieve the file then convert it to xcel for some data Pls advs commands and procedure to connect to the machine...oh my god... (1 Reply)
Discussion started by: sauravjung
1 Replies

7. Shell Programming and Scripting

confused with cp

may i know what cp $1 $2 $0 $2 does? (12 Replies)
Discussion started by: C|[anti-trust]
12 Replies

8. UNIX for Dummies Questions & Answers

confused

hi! how when i'm chattin inside com there was this chatter andi don't know what he did but he saw all my files inside my shell. what did he do? (4 Replies)
Discussion started by: hapiworm
4 Replies

9. UNIX for Dummies Questions & Answers

confused,,,,

Hi,,, is there any possibility to install Linux in my P.C which is use Win98 without loose anything from my hard disk???? ---------------------------------------------------------------------------------- Is it better for a newbie in this kind of OS to install Linux instead of... (5 Replies)
Discussion started by: spyros
5 Replies
Login or Register to Ask a Question