utl_file open error

Posted on 16th Feb 2014 07:03 pm by admin

i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name: qua01

this path is hard coded in the table PQ10. i will be taking this value and get assinged to the variable "Var_val"

DECLARE
Fic_Lu UTL_FILE.file_type ;
Var_val VARCHAR2(50);
vs_mod_r := 'r' ;
SELECT val
* INTO Var_val*
* FROM pq10*
* WHERE pq10_COD_PRM='RF';*
Fic_Lu := UTL_FILE.FOPEN ( Var_val,'qua01', vs_mod_r, 3000 ) ;
exception
WHEN UTL_FILE.INVALID_PATH THEN
dbms_output.put_line(' Invalid path');
end;
while i run i get invalid path error

Give me ur suggestion

Your Answer:

Login to answer

Other forums

PHP Captcha Error help - replace the "die" command
Hi All,

I am after a bit of help with a Captcha spam protection box.

The site gave me

Session
I am having a little trouble with a session. Not sure if it is my browser or what. I know I do not

Help Ordering Arrays
Hi, I have 3 arrays as shown below.

Code: $users = $this->get_latest_users();
$flir

Confused with Loop
guys, i got confused with Looping...this is the case

I have 3 stocks, let say "Stock A&q

COOIS - Saving Object Overview WIP Status layouts
COOIS - Would like to be able to save the layout of an Object Overview - WIP Status report. There i

Gaining access to Drop Down Menu Variable
code is below, I am creating a drop down menu. I want to echo the value selected in the drop down me

passthru() help
Hi everyone,
I'm new to the forum and to PHP. I have some pretty good experience writing shell sc

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

1,000 select boxes with 100 options?!
I have 1 drop down select box with 1,000 options.


In some case, there will be 100+ of the

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan