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/mysql auto logout after 2 hour and reset password
Hi all,

This I hope will make sense. I've the following code which when a user logins in, cr

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

email form (cannot find the problem)
Hello there. I've been having trouble with an email form. Can't find the problem really. I've tested

what does this mean? +=
is anyone able to explain what this code is saying?

i had it written for me awhile back and n

Onclick problem in Firefox
Hi,
I am using a . It doesn't seem to

Data type mismatch
Hi,
I am migrating data from algol to c.I mapped real datatype in algol to double datatype in

php email checker
I am having alot of trouble finding info on how to do these email things. I need to do the following

ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al

max() problem
I have a while loop to get image names.
Code: $imagequery = mysql_query("SELECT * FROM ad_i